deleting workbook names in excel

  • Thread starter Thread starter Liz Gewirtz
  • Start date Start date
L

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