How can I bring up the brose pop-up screen with VBA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Ty this

Dim str As String

str = Application.GetOpenFilename

This does not open the file but rather just retuns the name and path of the
selected file...
 
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
 
Thank you.

Tom Ogilvy said:
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
Click to expand...
 
Thank you Jim

Jim Thomlinson said:
Ty this

Dim str As String

str = Application.GetOpenFilename

This does not open the file but rather just retuns the name and path of the
selected file...
Click to expand...
 

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

How can I stop a windows Media player pop up on my PC 3
Windows Mail EMail Messages Lock-Up 15
Excel vs Lotus [pop-up screen with directories] 3
"Nag Screen" pop up 4
fast way to convert and burn RMVB to DVD/SVCD/VCD 0
Nag screen pop up 1
Create Pop-Up quiz Window with yes no questions 0
VBA in IE window 1

Back
Top