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

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

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

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...
--
HTH...

Jim Thomlinson


"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

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

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

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

Thank you.

"Tom Ogilvy" wrote:



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

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

Thank you Jim

"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"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