ms access - 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 = "\serverInstructions"

Shell "C:WINDOWSexplorer.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.