fname = Application.GetOpenFileName()
if fName < False tthen
msgbox "You chose " & fname
End if

See Excel VBA help of GetOpenFilename for additional arguments.

Regards,
Tom Ogilvy



"Richard" wrote:

Hello,

I want to use the BVA code to bring up the brose pop-up screen (this the
same screen that when we click on "Open" file to brose the file to open).

After user brose and select the file, I want to capture that file name.

Can anyone help me with this?

Thanks