View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
E.Anderegg E.Anderegg is offline
external usenet poster
 
Posts: 12
Default 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