Macro "Save as"

[digitel]

Hi all,

Is there a way to do this ???

To save an excel sheet to:

c:\filename.xls

where "filename" is the text content of a specific cell (of same sheet we are saving...)

Note that we compile more times the same sheet , so that particular cell will change its content therefore more "filenames" will be created

Thank you for every answer.

Federico

 

[Jon von der Heyden]

Is this what you're looking for?

    ActiveSheet.Copy
    ActiveWorkbook.SaveAs Filename:="C:\" & Range("A1").Value & ".xls"

You could add this to your personal macros if you like, or you could even change Range("A1") to and InputBox so that the user inputs the name for each sheet...

Hope I got the jeist of your question.

 

[digitel]

Hi,
Simply great.......
Thank you very much !!!
Bye