I have an intermittent problem with Excel 2003. I am manipulating files and
make a copy of the orginal worksheet before I start working on it. Sometimes
when I try to move and copy a worksheet I get the message ‚ÄúPath/File access
error: ‚ÄėVB1A.tmp‚Äô. The text after ‚ÄúVB‚ÄĚ but before ".tmp" changes each time
this error occurs.
I encounter this when I try to move and copy a sheet by right-clicking on
the sheet tab, as well as when I run a macro with the following statement:
This is only an intermittent problem. It is not cleared by closing Excel
restarting my computer. I have tried the following:
Cleaned out all temp folders, including Internet Explorer
Gone into Add/Remove programs and run the Repair for Office
Uninstalled and reinstalled Excel
Defragged my hard drive
Copy the data from the workbook and paste it into a new workbook.
My company‚Äôs tech support can‚Äôt offer any
other ideas. I hope someone in
this community might be able to help.