Open dialog box and browsing in Excel

  • Thread starter Thread starter Mike Mertes
  • Start date Start date
M

Mike Mertes

Good afternoon [more] expereienced developers [than I]!,

I simply want to replicate the already common "browse," feature found in
many applications for setting file names and paths so that users do not have
to memorize them.

For instance, "Application.FindFile," allows the user to select a file,
opens the selected file, and returns "True," to excel if the file was
successfully opened. However, I would like to use or create a function that
does not open the file, but instead returns the file name, path (absolute or
relative,) or a filesystem object representing the selected file.

Thanks in advance for your help!
-Mike
 
Hi Mike,

Take a look at Application.GetOpenFilename and Application.GetSaveAsFilename
in VBA help - those do exactly what you're looking for.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Hi
look at
application.getopenfilename
and
application.getsaveasfilename

in the Excel helpfile
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Browse dialoge 2
open dialog box 1
Excel 2003 - Save as dialog box 9
Browse button for access form 1
Browse using MS Dialog 2
Can I display an open file dialog from a macro 7
How to browse folder and open xls file automatically in vba? 6
Code to Insert File as Icon & Open Browse Dialog Box 5

Back
Top