Hi All
I open a couple of Excel Workbooks through VB Code, save and close them. At times, not this has become often, temporary files (like 09fe45fsf) are getting created and the Workbook, which I intend to save is not getting saved.
How to avoid Excel creating Temp Files
My workbooks are not shared, but have links to other workbooks
Many thanks in advance
Shasur
Avoid Temp File Creation by Excel
guyinkalamazoo2
Hi Shasur
I have experienced the problem you describe, the problem was not Excel but the stability of our network. If you lose the connection to a mapped drive / network folder and it re-establishes while you are working, you cannot save the file , but excel saves it using a combination of letters and numbers.
elixic
hi, if Excel crashes then it attempts to recover lost work but restoring files that it finds, those could be the files it tries to restore. I've noticed the files but they should be deleted when Excel closes. Are they deleted