wfsave to Excel or CSV crashing
Posted: Fri Oct 25, 2024 10:04 am
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)
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)
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?
- resdataa_bug.png (15.03 KiB) Viewed 91999 times
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 91999 times