Help: Shell out to File Explorer

[Guest]

I want to fire up File Explorer and open it to a specific folder on the
network. How would I code that?

 

[Dirk Goldgar]

In

I want to fire up File Explorer and open it to a specific folder on
the network. How would I code that?

Have you tried just following the folder path as a hyperlink, like this:

Dim strFolderPath As String

strFolderPath = " ... your path to the folder in question ..."

Application.FollowHyperlink strFolderPath

 

[Scott McDaniel]

I want to fire up File Explorer and open it to a specific folder on the
network. How would I code that?

Dev Avish's site has code that shows how to do this:

http://www.mvps.org/access/api/index.html

The first two listing would be of interest to you.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Douglas J. Steele]

Dev Avish's site has code that shows how to do this:

http://www.mvps.org/access/api/index.html

The first two listing would be of interest to you.

That may not be what Perico is looking for. The first two listings on the
page you cite are for how to invoke the standard Windows File Open/File Save
and Browse For Folder dialogs respectively. That's not the same as opening
File Explorer in a specific folder (although without knowing the ultimate
requirement, it may suffice)

 

[Guest]

Dirk's solution works well for my purpose. Thanks all for the help.