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?
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.