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 |
deleting workbook names in excel
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 |
All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com