Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"save as" macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Macro in WB assigned to toolbar, after "save as" points to differn | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) |