Need VBA assistance for Excel Open Dialogue Box

[Brent E]

Good morning.

I need to figure out code that will simply change current directory to a set
directory and then show Excel's "Open" Diaglogue box. I am aware that I can
use an open command to open a certain file, but I don't want to do that,
just Excel's Open dialogue box. Any suggestions? Thanks

Cordially,

[Tom Ogilvy]

sPath = "C:\MyFolder"
chdrive sPath
chdir sPath
application.Dialogs(xlDialogOpen).Show


also look in excel vba help at Application.GetOpenfileName

--
Regards,
Tom Ogilvy



"Brent E" <[email protected]> wrote in message
news:[email protected]...
> Good morning.
>
> I need to figure out code that will simply change current directory to a
set
> directory and then show Excel's "Open" Diaglogue box. I am aware that I
can
> use an open command to open a certain file, but I don't want to do that,
> just Excel's Open dialogue box. Any suggestions? Thanks
>
> Cordially,
>

[Brent E]

Really cool. Thanks Tom.

"Tom Ogilvy" wrote:

> sPath = "C:\MyFolder"
> chdrive sPath
> chdir sPath
> application.Dialogs(xlDialogOpen).Show
>
>
> also look in excel vba help at Application.GetOpenfileName
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Brent E" <[email protected]> wrote in message
> news:[email protected]...
> > Good morning.
> >
> > I need to figure out code that will simply change current directory to a
> set
> > directory and then show Excel's "Open" Diaglogue box. I am aware that I
> can
> > use an open command to open a certain file, but I don't want to do that,
> > just Excel's Open dialogue box. Any suggestions? Thanks
> >
> > Cordially,
> >
>
>
>