I use the TransferSpreadsheet command to export tables of information to Excel and it always works very successfully. But, when I tried it today I hit a hang up. The information transfers to the Excel file, but it corrupts the file. When I open the file it says "Excel.exe has generated an error and will now be shut down" and then it shuts Excel down completely.
I just thought someone else may have got this error and knows what is causing it. I've tried everything, even letting Access create the sheet tab in the file and then exporting it, but it still corrupts my file. This function works for me every month to about 150 different Excel files, so I'm not sure what is going wrong....Help!
I just thought someone else may have got this error and knows what is causing it. I've tried everything, even letting Access create the sheet tab in the file and then exporting it, but it still corrupts my file. This function works for me every month to about 150 different Excel files, so I'm not sure what is going wrong....Help!
