View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Liz Gewirtz Liz Gewirtz is offline
external usenet poster
 
Posts: 1
Default deleting workbook names in excel

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