joehanna/gist:79b1842f4516570fd3cc

Created March 30, 2015 23:42

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/joehanna/79b1842f4516570fd3cc.js"></script>
Save joehanna/79b1842f4516570fd3cc to your computer and use it in GitHub Desktop.

Download ZIP

VBA: Open Windows Explorer with a specific file selected

Raw

gistfile1.vb

	Dim fileName as String

	fileName = "C:\Windows\notepad.exe"

	Shell "explorer.exe /e,/select," & fileName, vbNormalFocus

apsis0215 commented Jan 18, 2023 •

edited

Loading

In excel 2016+

Dim Filepath as string
VBA.Shell "C:\windows\explorer.exe /select, " & "" & filepath & "", vbNormalFocus

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment