Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / February 2006

Tip: Looking for answers? Try searching our database.

Saving file using Explorer Style box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
n_s_simpson - 28 Feb 2006 13:07 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.