Macro to "save as"

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

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.
 
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.
 
Back
Top