Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

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

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