Opening and viewing specific folders from a vba command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikejs2000 - 18 Jan 2006 13:31 GMT

Hi,
I think this should be a simple one.
I want the user to click a button associated to a specific project and have
windows explorer open up showing that projects working folder.

Mike J. Soames

Reply to this Message

Brendan Reynolds - 18 Jan 2006 13:46 GMT

There's an example showing how to call the windows Browse for Folder dialog
at the following URL ...

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

Signature

Brendan Reynolds
Access MVP

> Hi,
> I think this should be a simple one.
[quoted text clipped - 3 lines]
>
> Mike J. Soames

Reply to this Message

Ofer - 18 Jan 2006 13:50 GMT

Try using

Dim MyPath as String
MyPath = "c:\"
Application.FollowHyperLink MyPath

Signature

\\// Live Long and Prosper \\//
BS"D

> Hi,
> I think this should be a simple one.
> I want the user to click a button associated to a specific project and have
> windows explorer open up showing that projects working folder.
>
> Mike J. Soames

Reply to this Message

mikejs2000 - 18 Jan 2006 14:05 GMT

Brenda, Thanks for you reply but what you sent was just a bit to complex for
what I required. Thanks again.

Ofer, That did it, nice and simple. Thanks.

Mike J. Soames
Happy coding to all

> Try using
>
[quoted text clipped - 8 lines]
> >
> > Mike J. Soames

Reply to this Message