LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default file not found ...\local~\temp\vb514.tmp

Hello,

This is driving me crazy. When I try to create a copy of a worksheet I get
the following error: c:\...\local~\temp\vb514.tmp. If I then turn off
"ignore other applications" I can do the copy. But the very next time I try
a worksheet copy the same error occurs. If I then toggle "ignore other
applications" ON, it solves it. So, it seems all I need to do is toggle.

The spreadsheet I copy has macros in it. If I cleanse the workbook of
macros by saving as .xml, then rename as .xls, the problem is solved. But as
soon as I add macros the problem comes back. Even if I don't add back
macros, but simply have the VB editor open, the problem occurs. I also get
prompted to enter the password for "funcres", which I have no idea what is.

The problem occurs on other machines with the same spreadsheet. I deleted
all my temp files but no luck. Seems to be only with this spreadsheet. The
spreadsheet was created in 2003. I am using Excel 2003.

Thanks for your help,
Nathan

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp Yuvraj Excel Discussion (Misc queries) 3 May 3rd 09 11:59 AM
file not found ...\local~\temp\vb514.tmp nathan Excel Discussion (Misc queries) 7 June 22nd 07 08:45 PM
Original Excel File gets deleted and temp file gets created. Sandy[_7_] Excel Programming 11 December 12th 06 01:31 AM
Accessing local workstation's TEMP directory Frederick Chow Excel Programming 5 March 20th 06 05:04 PM
shared workbook, local temp-file and network traffic petri Excel Discussion (Misc queries) 0 September 12th 05 10:51 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"