Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set XLApp = createobject("Excel.Application") doesn't work

hi,

I programmed a macro a while ago and it was always working fine but since yesterday I can't create the excel application-object!! does anyone know why this is happening all of the sudden?

the Error is: Out of memory 'XLSheet.Range'

regards

MT

1 Reply
marcus_sommer

Perhaps the amount of data is really too large or somewhere within the data are now invalid values. Sometimes it needed only a restart from system (I had had only yesterday such a case). If this not helped, I would suggest you tried it again with smaller datasets to find the cause-area.

- Marcus