file not found ...\local~\temp\vb514.tmp

[nathan]

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

 

[Dave Peterson]

You have another response at your other post.

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

 

[nathan]

Thanks. I posted this question yesterday in the application error category
and got no repsonses, so today I switched to the shotgun approach by posting
to multiple categories. Hope that isn't a faux pas!

 

[Gord Dibben]

If you want to hit several news groups it is better to Cross-post rather than
Multi-post.

The difference being most of us with news readers can mark the messages as read
or flag them if they are cross-posted.

Multi-posting just creates multiple responses which is a waste of time and leads
to much duplication of answers.

To cross-post just enter the news groups separated by commas in the Newsgroups
line.

microsoft.public.programming, microsoft.public.excel,
microsoft.public.excel.misc


Gord Dibben MS Excel MVP