| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save a vary filename by Macro in Excel?
I want to save a new filename every time after running the Macros
to the current path. As the master file will transfer to different user, so the file path may also vary. And want to set the filename same as one of the cell content. As the cell content will auto update for each time running the Macros. So, could anyone give me some hints for finish this task ? Thanks very much |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to save a vary filename by Macro in Excel?
Dim rng as Range
set rng = Worksheets("Sheet1").Range("A1") activeworkbook.SaveAs rng.Value & "\" & activeworkbook.name -- Regards, Tom Ogilvy "mc" wrote in message ... I want to save a new filename every time after running the Macros to the current path. As the master file will transfer to different user, so the file path may also vary. And want to set the filename same as one of the cell content. As the cell content will auto update for each time running the Macros. So, could anyone give me some hints for finish this task ? Thanks very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a Macro to "save as" filename from a cell on the sheet and then pr | Excel Discussion (Misc queries) | |||
| Macro to save file as different filename | Excel Worksheet Functions | |||
| EXCEL macro that will vary when copied | Excel Worksheet Functions | |||
| Save excel file with filename = cell text | Excel Programming | |||
| Can a MACRO prompt for the filename to open and/or save? | Excel Programming | |||
Linear Mode
