I am exporting some data to an excel file. My code works perfectly for the first couple of exports and then I get this error:
Not enough storage is available to complete this operation.
If I reboot my pc it begins to work but only for a couple of times until it errors again.
Excel isn't being opened at any time and I am closing my recordset and setting it to nothing after each export.
Any clues anyone?