"save as" macro

[Guest]

Happy Holidays

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

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

 

[Izar Arcturus]

Hello Peter,

Try this:

Private Sub FlexibleSaveAs()
ActiveWorkbook.SaveAs Filename:=Range("A1").Value
End Sub

-IA

-----Original Message-----
Happy Holidays!

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