View Single Post
  #1   Report Post  
Old November 23rd 06, 03:12 AM posted to microsoft.public.excel.misc
goneill3 goneill3 is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 3
Default 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
error.
If I open the (network) file via windows explorer I don't have a problem
copying worksheets.
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
error.
I haven't tested Office 2007 yet.

Any feedback would be appreciated.