469,267 Members | 979 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

Open WinExplorer from Access VBA ?

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)
Nov 13 '05 #1
4 6261
are you trying to shell out to an application that opens the file?
Then just format the filename/path as a hyperlink.

Nov 13 '05 #2
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]

Nov 13 '05 #3
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
Nov 13 '05 #4
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)

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by BjoernJackschina | last post: by
6 posts views Thread by Kenneth Courville | last post: by
2 posts views Thread by existential.philosophy | last post: by
14 posts views Thread by SimeonD | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.