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 'filesave 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

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"
wrote in message
...

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 'filesave 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

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

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