Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As macro
I have been having trouble getting a macro to work like I
want. I want a macro to "save as" wookbook that will change drive and folder in the "save as" "save in window" that will allow me to change the file name but populate the new drive and folder automaticly but allow me to input new file name. I have been able to create a statement, but I have to manually change drive. I want to accomplish the change of drive and folder w/o manual intervention. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As macro
Don't know if this is what you want, but give it a try.
Chdrive "D" Chdir "D:\My Documents" fname = Application.GetSaveAsFileName() -- Regards, Tom Ogilvy tjgriffi wrote in message ... I have been having trouble getting a macro to work like I want. I want a macro to "save as" wookbook that will change drive and folder in the "save as" "save in window" that will allow me to change the file name but populate the new drive and folder automaticly but allow me to input new file name. I have been able to create a statement, but I have to manually change drive. I want to accomplish the change of drive and folder w/o manual intervention. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Save As | Excel Discussion (Misc queries) | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Please help macro for save | Excel Worksheet Functions | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
Prompted to save changes after macro save - why? | Excel Programming |