I am getting this error on my prod server:
Microsoft Excel (0x800A03EC)
Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to.
The code runs great on my Dev box...the prod server is a lot more powerful than the other one and definitely has enough memory and space.
Any ideas ?
Set xls = CreateObject("Excel.Application")
' Make sure there is no minimized window created
.Application.Visible = False
' Add a new workbook
.Workbooks.Add <<<< This is where it fails >>>>