Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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