deleting workbook names in excel

[Liz Gewirtz]

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

 

[BrianB]

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
====================================