"save as" macro
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
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 help
.
|