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?
.
|