SaveAs problem, renames Worksheet too
I have a workbook with different sheets.
In a macro i get the desired Filename with applicationGetSaveAsFilename .... then with activeworkbook.saveas I try to save it programmatically. The file is saved under the correct name, but unfortunately the active worksheet ist renamed with the filename. How can I avoid it? Thanks for all help Ernst |
SaveAs problem, renames Worksheet too
If I understand you correctly....
from the excel help file: Saves a copy of the workbook to a file but doesn't modify the open workbook in memory. Syntax expression.SaveCopyAs(Filename) expression Required. An expression that returns a Workbook object. Filename Required. Specifies the file name for the copy. -----Original Message----- I have a workbook with different sheets. In a macro i get the desired Filename with applicationGetSaveAsFilename .... then with activeworkbook.saveas I try to save it programmatically. The file is saved under the correct name, but unfortunately the active worksheet ist renamed with the filename. How can I avoid it? Thanks for all help Ernst . |
All times are GMT +1. The time now is 10:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com