Saving file using Explorer Style box

[n_s_simpson]

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

[Tom Ogilvy]

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.

--
Regards,
Tom Ogilvy

"n_s_simpson" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
>
> --
> n_s_simpson
> ------------------------------------------------------------------------
> n_s_simpson's Profile:
http://www.excelforum.com/member.php...o&userid=31859
> View this thread: http://www.excelforum.com/showthread...hreadid=517280
>

[n_s_simpson]

I feel like a real idiot now. Thanks for your help Tom.

Nick