By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Open WinExplorer from Access VBA ?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.