I use the TransferSpreadsheet function in my Access macros to export tables of information to Excel. This works well for me all the time, but I recently got an error message when trying to open the file that I exported to. Once the informaiton is exported, it corrupts the Excel file and when I open it, it completely shuts down Excel. I cannot figure out what I am doing differently with this table. Has anyone else experienced this problem???
Stacy
Stacy