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


.