Delete .emf files in Excel

G

giorgio

Hello,

I found one of my Excel files is creating hundreds of .emf files in the
temp directory every time I open it. This causes the Excel file to
take almost an hour to open. I clear out the temp directory all the
time, but how do I delete the .emf files permanently from the file or
at least keep them from opening?

Please help....

Thanks,

George
 
D

Dave Peterson

I don't think you can stop excel (and other programs) from using that temp
folder. (In fact, you wouldn't want to.)

But I use a script by Michael Harris to clean up my Temp folder.
http://groups.google.com/groups?threadm=#bXVsIHnAHA.920@tkmsftngp02

I store the .vbs file in a nice safe folder and put a shortcut to it on the
desktop. I run that script whenever I want (right when I turn the pc on or
right before I turn it off).
 
G

giorgio

Awesome thanks, but is there a way to permanently remove the .emf
files from the Excel File (I dont have any images in the file). Even
when my temp folder is empty, it takes forever to open this Excel file
b/c it needs to create hundred of .emf files in the temp folder to
open......

any help or am I looking at this the wrong way?
 
D

Dave Peterson

I don't think you can stop excel from creating these files. It'll create
whatever it needs (which is good thing!).

I think the best you can do is clean up often.
 
G

giorgio

Ok, thanks. It just sucks because even with a completely empty temp
file. My excel workbook take 30minutes to open because is has to write
all these .emf files on my temp drive. I wish I could figure out what
the point of it was.

I really appreciate your help Dave

George
 
D

Dave Peterson

What objects do you have in that workbook?

Try deleting some of them (against a copy) and see what happens.

Maybe you can remove some of those control toobox toolbar controls (and replace
them with Forms controls)???

(or is it the userforms causing the trouble.)
 
G

giorgio

Dave,

Removing those control toolbox toolbar controls did the trick!

THANKS a MILLION!!
 
Top