Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Save worksheet to new document
Hi all,
I need create a macro that will: - copy a Tab from one workbook into a new workbook - Save to a specific path to a shared server, with a unique name (dept) What I've done: I can get the macro to copy to a new workbook, and the path to the right server, but I don't know how to input the unique name (dept). Other info: - The unique name (dept) is available in the document (from a drop down box the user selects), but I can't figure out how to copy it into the "save" function in the macro. I've tried the control keys, but that didn't work. - Could I have the user type it in (use a sub-macro or some kind of input form?) Any help would be appreciated. Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to automatically save document with cell reference as filena | Excel Discussion (Misc queries) | |||
file size after using macro to save a worksheet | Excel Programming | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
Macro to save worksheet | Excel Programming | |||
Macro to save file and print document | Excel Programming |