Take a look at the GetOpenFileName method in help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank E" wrote in message
...
I would like to know the VBA coding required to have a button run a macro
which will open up a file directory search box and allow the user to select
a specific text file for import later in the macro. Help please.