| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save file in a macro taking new name from cell contents?
I want to Save-as a file from within a macro, taking the new name from the
worksheet's cell contents. I want to save an order form with a file name based on the order number contained in a worksheet cell. My question is how to get the cell contents into the Save-as dialog box when the macro calls the Save-as function. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| macro save a file name from a cell in 1st worksheet | Excel Discussion (Misc queries) | |||
| Using "Save As" with a file name selected by cell | Excel Discussion (Misc queries) | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) | |||
Threaded Mode
