tmp files - millions and millions of 'em!

[J. Shrimp, Jr.]

Actually there's between 3,000 and 4,000 tmp files created every time
our Excel spreadsheet is run. Excel spreadsheet creates other Excel
spreadsheets if a new project is selected - beginning another instance of
Excel each time.

After more than two projects are opened at the same time,
the performance of Excel deteriorates to a point where
you can't run Excel (it takes forever to load) the next time you open the
spreadsheet.

The tmp files are created in ...\Local Settings\Temp directory.
Is there a reason these tmp files are being created?

 

[Charles Williams]

Excel needs temp files to operate, so does VB and VBA , and Forms tend to
create a lot of temp files.

I suggest you:
- delete ALL the temp files
- change your spreadsheet so that it opens a new workbook within the same
instance of Excel rather than creating an additional Excel instance.


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm