Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As dialog box in macro
Last week I learned how to invoke a FileOpen dialog box
in a macro so that the filename could be inserted at runtime. I need to do the opposite now--bring up a Save As dialog box to let the user navigate and enter a file name. Where can I find the code to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As dialog box in macro
Right he
Sub test() Dim F As Variant F = Application.GetSaveAsFilename MsgBox F & " rules" End Sub HTH. Best wishes Harald "Dennis" skrev i melding ... Last week I learned how to invoke a FileOpen dialog box in a macro so that the filename could be inserted at runtime. I need to do the opposite now--bring up a Save As dialog box to let the user navigate and enter a file name. Where can I find the code to do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As dialog box in macro
Look at GetSaveAsFileName method in VBA help.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dennis" wrote in message ... Last week I learned how to invoke a FileOpen dialog box in a macro so that the filename could be inserted at runtime. I need to do the opposite now--bring up a Save As dialog box to let the user navigate and enter a file name. Where can I find the code to do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As dialog box in macro
Thanks! Works great!
-----Original Message----- Right he Sub test() Dim F As Variant F = Application.GetSaveAsFilename MsgBox F & " rules" End Sub HTH. Best wishes Harald "Dennis" skrev i melding ... Last week I learned how to invoke a FileOpen dialog box in a macro so that the filename could be inserted at runtime. I need to do the opposite now--bring up a Save As dialog box to let the user navigate and enter a file name. Where can I find the code to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as dialog | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
Changing Save As Type in Save as dialog box | Excel Programming | |||
Save As Dialog | Excel Programming | |||
Save As Dialog | Excel Programming |