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.