How to open a folder in Windows Explorer from VBA?

Question

I want to click a button on my access form that opens a folder in Windows Explorer.

Is there any way to do this in VBA?

Answer 1

You can use the following code to open a file location from vba.

Dim Foldername As String Foldername = "\\server\Instructions\"  Shell "C:\WINDOWS\explorer.exe """ & Foldername & "", vbNormalFocus 

You can use this code for both windows shares and local drives.

VbNormalFocus can be swapper for VbMaximizedFocus if you want a maximized view.

Answer 2

The easiest way is

Application.FollowHyperlink [path] 

Which only takes one line!