Excel 97 Save causes Temporary files to be opened

[Dominic]

I have a .XLT file installed on a users pc.
The file was originally created using Excel 2000 but, for
various reasons, we have had to convert this to Excel 97 -
the VBA code has been re-compiled and the file saved as a
template.
The spreadsheet uses VBA code to save and close the
template file which works fine during testing. However,
on my user' PC, when it tries to save the template a
series of TEMP files are opened. These files keep opening
and we have got as far as temp17 before using Task manager
to end Excel.
On checking the files directory the template files are not
being deleted as they should be (presumably down to
closing Excel using the Task manager)
My initial thoughts are that it is something to do with a
combination of the save process and the machine speed. No
other applications are running and they are using a
machine with 64mb of memeory so this shouldn't be a
problem.
Despite searching TechNet and various Search Engines I
have yet to find either a problem that matches the one I
descrivbe or a solution.

Does anyone have any idea as to why this should be
happening or offer any sort of solution.

Thank you in advance of your help.

Dom

 

[Dave Peterson]

I've never seen anything like this.

You may want to post the relevant portion of code that caused this (not the
workbook) to see if anyone can help.

 

[Dom]

Unfortunately it is not code that necessarily causes this -
it can also be using the file save command or the save
toolbar button.
Not much help but may narrow it down a bit.

 

[Dave Peterson]

I don't have a guess, but if you start excel in safe mode:

Windows Start button|Run
Excel /safe

Does the problem still occur? If no, then maybe you have an addin "helping"
you.

You can check to see what's running by starting excel normally (not safe mode),
then hit alt-F11 to see the VBE. Then hit ctrl-R to see the project explorer.

From there you can tell what's running.

I see this in mine:
atpvbaen.xls (ATPVBAEN.XLS) (analysis toolpak for VBA stuff)
funcres (FUNCRES.XLA) (anaylsis toolpak for Excel stuff)
personal (personal.xla) (my own set of macros/functions)
VBAProject (book1) (initial empty workbook)

if you see something that you didn't start and looks suspicious, then maybe
that's the one causing trouble.

(I ain't willing to give up on macros gone bad.)

===========

Try to get the problem and then do the same check--to see if anything was loaded
when you clicked on the icon/file|Save option.

If some macro took control that icon, you might not even notice it.

If you want to try to reset the toolbars, you can:
tools|customize|toolbars
click on "worksheet menu bar" and then click Reset
click on "standard" and then click reset.

Try it out again.

(If you reset these menubars, then any custom changes you've made to them will
have to be rebuilt.)

 

[Dom]

Thanks, I'll try this and if it works I'll post another
reply.