Copying worksheet, path/file access error: '\vbxxx.tmp'
I am getting the following error when copying worksheets within a workbook,
path/file access error: '\vbxxx.tmp' but only under very specific condidions.
Open worksheet with macros from network via Execl's file open and copy a
worksheet inside a workbook produces the error.
If the spreadsheet doesn't have any macros, no problems. If I go and add a
macro, which is does nothing other than contain an empty function, I get the
If I open the (network) file via windows explorer I don't have a problem
If I copy the files to my local hard drive, no problems copying worksheets.
I have tested this on both Office 2000 and Office 2003 and they both get the
I haven't tested Office 2007 yet.
Any feedback would be appreciated.