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