• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro for saving workbook based on data string in cell A1

H

Hendrik

New Member
Hello,


I have stringed data from different cell values, in the same sheet, and it places the result in cell a1.


I would copy that value to note pad or word and then use that same text to save the work book.


Could you show me a macro solution that I can simplify the "file-save-as" process.
 
[pre]<br />
Activeworkbook.SaveAs Filename:=Range("A1").Value<br />
[/pre]
 
You must log in or register to reply here.
Back
Top