I have a lot of programs that have lots of exports to Excel. I have always found these commands tended to crash randomly. Sometimes I had to delete the excel file to get it to work but just rebooting would usually get it to run. (see attachment)
- resdataa_bug.png (15.03 KiB) Viewed 91977 times
Lately, I have been replacing all these commands with one that saves the data to a csv. Then I have VBA that opens the CSVs and copies them into the XLSX file that it used to go to. That is a lot more reliable, and it runs much faster (although the VBA now take a while to run).
I recently upgraded from version 12 to version 14 and now I occasionally have been getting this error going to a csv (although much less frequently). (see attachment)
- wfsave_error_to_csv.png (15.11 KiB) Viewed 91977 times
Any idea why this is happening? Is there anything I can do to make it happen less often? Perhaps I should re-install Excel? Or get more RAM?
