I have a template that runs an automacro that creates 3 worksheets,
manipulates them, closes them, etc. Sometimes, instead of opening
"tstemp.xls", excel will open tstemp1.xls, then tstemp2.xls, etc. Is
there a way I can clear out these names so that excel will always open
tstemp rather than the sequential numbering?

Thanks,
Liz

It looks like you have got your terminology wrong, which could be
giving rise to your problem. You can create and delete WorkSheets in a
WorkBook, but you can only Open and Close WorkBooks (files with .xls
suffix) from disk .

It seems more likely that there is an error in your code, because if
you use something like :-
Workbooks.Open FileName:="tstemp.xls"

It will either open that workbook if it is a valid procedure or give
an error message. If you have temporarily blocked error messages with
Application.DisplayAlerts = False, comment out the line to see if you
do get a message.

If your problem is not solved here I suggest you post your code in a
new message (many of us do not read ones already answered).

Regards
BrianB
====================================


(Liz Gewirtz) wrote in message . com...
I have a template that runs an automacro that creates 3 worksheets,
manipulates them, closes them, etc. Sometimes, instead of opening
"tstemp.xls", excel will open tstemp1.xls, then tstemp2.xls, etc. Is
there a way I can clear out these names so that excel will always open
tstemp rather than the sequential numbering?

Thanks,
Liz