File Browse Box

  • Thread starter Thread starter JONNIE
  • Start date Start date
J

JONNIE

I have a userform on my sheet. What i want is a command
buttom to bring up box which will enable me to browse
files on my hd and then select one to perform an action
on. Does anyone know how to do this?

Also can you have the default value pointing to a specific
folder?
 
See the Application.GetOpenFileName method. This will display a
standard File Open dialog box and return the complete path of the
chosen file. It does not actually open the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top