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]

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

[Trevor Best]

What-a-Tool wrote:

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.

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

--
[Oo=w=oO]

[Adam Bunter]

pi********@hotmail.com wrote in message news:<11**********************@z14g2000cwz.googleg roups.com>...

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

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

[What-a-Tool]

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" <Se****@IHateSpam.Com> wrote in message
news:3yF6e.47924$AL.23346@lakeread08...

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)