Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 97 Save Macro opening multiple temp files

Status
Not open for further replies.

Clanger67

Programmer
Mar 28, 2002
28
GB
Using Excel 97 SR2

Using an ActiveWorkBook.Save command. The workbook is saved but multiple, at last count 17, temp files (temp1, temp2) showing in the taskbar at the bottom of the screen.

No error messages are being displayed. Have searched MS sites and checked to make sure we have current SR's.

The only way to stop this is to go Task manager and closing Excel from there. This will then remove the temp files.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top