Hi People
Please can someone please tell me how I can include the facility to
open a file or save a file using an explorer based save as dialog box.
I can't seem to add an example image as there appears to be something
wrong with this forum. But what I'm talking about is a similar thing to
what you get when you select 'file>save as' or 'open...' from word,
excel, etc
Thanks
Nick

Signature
n_s_simpson
Tom Ogilvy - 28 Feb 2006 13:28 GMT
in excel vba help, see help on
Application.GetSaveAsFileName
and
Application.GetOpenFileName
these return the selection made by the user as a string (or array if
multiselect is set to true) which you can then act on to actually open or
save the file.

Signature
Regards,
Tom Ogilvy
> Hi People
>
[quoted text clipped - 9 lines]
>
> Nick
n_s_simpson - 28 Feb 2006 13:36 GMT
I feel like a real idiot now. Thanks for your help Tom.
Nick

Signature
n_s_simpson