View Single Post
  #2   Report Post  
Old November 23rd 06, 04:27 AM posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Copying worksheet, path/file access error: '\vbxxx.tmp'

I think that this has come up a couple of times--but I'm not sure if I've
seen/remember the solution.

I suggested this once:

Maybe cleaning up your temp folder will help.

close excel
windows start button|run
Delete all those files and folders.

It may be best to do this right after you reboot your pc, so that no other
programs are running that need any of these files.

If that doesn't help, try disabling your antivirus software (just temporarily)
to see if that helps.

But never got a reply that it worked.

I searched google again for "\vb" and .tmp and got a few hits.

One of them:

If you find a solution, please post back--then google will have it for the next

goneill3 wrote:

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
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
I haven't tested Office 2007 yet.

Any feedback would be appreciated.


Dave Peterson