Macro to "save as"

[Guest]

I want to make a macro that will "save as" my exel file using a cell content for the file name.(using copy-paste
When i do this, it copies the cell content into the macro as text, and so when the cell content changes for the next "save as"
the text in the macro does not.

 

[Guest]

Happy Holidays

Below is what is writen in the macro, as seen in the macro editor. The number in quotation marks, is the value that was in cell F3. If I change le last digit from a 5 to a 6 in F3 and run the macro again, it does not look at the new number in F3, and tries to re-save under the same name

ActiveCell.FormulaR1C1 = "031217PH1855

Thanks for any hel

----- Peter wrote: ----

I want to make a macro that will "save as" my exel file using a cell content for the file name.(using copy-paste
When i do this, it copies the cell content into the macro as text, and so when the cell content changes for the next "save as"
the text in the macro does not.