Saved from a previous post:

Add some controls to a worksheet from the control toolbox toolbar and you'll see
some .tmp files in the %temp% folder. But I've never seen excel put them in any
other location.

If those .tmp files look like: ...\VB*.tmp

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

One of them:
http://groups.google.co.uk/group/mic...1eecaad1c774cc
or
http://snipurl.com/1339g

One person posted that they saw files that had names like: ~RF26c83af.TMP.

It was caused by AVG.

You can read her description in this thread:
http://groups.google.co.uk/group/mic...cd4eed0638e395

or
http://snipurl.com/jyus

A while ago, someone posted back that uninstalling something called "Panda
ClientShield" fixed a similar problem.

Even if you're not running "Panda ClientShield", you could try disabling this
program to see if the problem goes away.

nathan wrote:

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