I assume you mean the EMF files generated by excel
in the temp folder?

These files are generated only/mostly?
for embedded controls on worksheets.

So your code may create sheets with embedded controls?


Either:
get rid of the embedded controls and replace
with native controls from the form toolbar.


close excel properly when your routine finishes.
when excel is closed (not Terminiated via API)
it should (and normally does) clear up any
mess left in the temp dir.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Joshua Campbell" wrote:

I have a program that starts an instance of Excel 2002, creates a
spreadsheet, prints it, and closes. It does this roughly 400 times a
day. As you can imagine, this means that a lot of .emf files are going
to be created by Excel, and this can fill up a hard drive if left
unchecked. Is there a way to keep Excel from creating these files?

Thanks.
Joshua