ExcelBanter - File Browse Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - File Browse Box (https://www.excelbanter.com/excel-programming/290390-file-browse-box.html)

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

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

Chdrive "C"
Chdir "C:\Myfolder"
fName = Application.GetOpenFileName()

--
Regards,
Tom Ogilvy

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