Open WinExplorer from Access VBA ?

[What-a-Tool]

Is it possible to open windows explorer to a particular directory, maybe
even select a particular file, from Access VBA?

I have a DB that is loaded with a file list - certain files I open in their
native program, others it would be nice if I could open explorer up to the
files location.

If anyone can give, or direct me to a code sample, I would greatly
appreciate it.

Thank You

--

/ Sean Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

[pietlinden@hotmail.com]

Re: Open WinExplorer from Access VBA ?

are you trying to shell out to an application that opens the file?
Then just format the filename/path as a hyperlink.

[Trevor Best]

Re: Open WinExplorer from Access VBA ?

What-a-Tool wrote:[color=blue]
> Is it possible to open windows explorer to a particular directory, maybe
> even select a particular file, from Access VBA?
>
> I have a DB that is loaded with a file list - certain files I open in their
> native program, others it would be nice if I could open explorer up to the
> files location.
>
> If anyone can give, or direct me to a code sample, I would greatly
> appreciate it.[/color]

Just shell the directory name using the ShellExecute API (Google: "VB
ShellExecute")

--
[Oo=w=oO]

[Adam Bunter]

Re: Open WinExplorer from Access VBA ?

pietlinden@hotm ail.com wrote in message news:<111327039 2.980393.223570 @z14g2000cwz.go oglegroups.com> ...[color=blue]
> are you trying to shell out to an application that opens the file?
> Then just format the filename/path as a hyperlink.[/color]

http://www.mvps.org/access/api/api0018.htm

[What-a-Tool]

Re: Open WinExplorer from Access VBA ?

Thanks for the helpfull pointers - I'm sure I'll be able to get it going
with all the helpfull examples I've turned up

Thanks again

--

/ Sean Mc /


"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

"What-a-Tool" <SeanMc@IHateSp am.Com> wrote in message
news:3yF6e.4792 4$AL.23346@lake read08...[color=blue]
> Is it possible to open windows explorer to a particular directory, maybe
> even select a particular file, from Access VBA?
>
> I have a DB that is loaded with a file list - certain files I open in
> their native program, others it would be nice if I could open explorer up
> to the files location.
>
> If anyone can give, or direct me to a code sample, I would greatly
> appreciate it.
>
> Thank You
>
> --
>
> / Sean Mc /
>
>
> "I have not failed. I've just found 10,000 ways that won't work."
> - Thomas Alva Edison (1847-1931)
>
>[/color]