"save as" macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
the cell content into the macro
as text, and so when the cell content changes for the
Click to expand...
next "save as", the text in the
 
Back
Top