E
E.Anderegg
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
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