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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
screen goes blank after screen saver and cant bring it back	=?Utf-8?B?QVJn?=	Windows Vista Performance	1	24th Sep 2007 08:02 PM
bring screen to foreground	=?Utf-8?B?amVmZg==?=	Microsoft Dot NET Compact Framework	4	22nd Feb 2007 06:16 PM
cant bring up the screen to log in.	=?Utf-8?B?c2t1bG1hdA==?=	Windows XP General	2	21st Apr 2005 05:45 PM
Help me Bring back Welcome screen after screen saver	=?Utf-8?B?Ui4gSmFtZXM=?=	Windows XP Help	6	8th Apr 2005 04:35 AM
bring certain form to the top of screen	wd1153	Microsoft Access Form Coding	1	20th Dec 2003 02:12 PM