Open Windows Explorer from Excel

[Guest]

Hello

Is it possible to open Windows Explorer from Excel and show specfic folder path using VBA

Thanks in advance
James

 

[Tom Ogilvy]

ActiveWorkbook.FollowHyperlink

see help for details.

 

[Ron de Bruin]

Try this James

Sub test()
Shell "explorer.exe C:\Dell", vbNormalFocus
End Sub

 

[Tom Ogilvy]

Whoops, I guess you said Windows Explorer rather than Internet Explorer
although you could use Internet Explorer as well.

 

[Jon Peltier]

This one opens it with the folder pane on the left.

Sub test()
Shell "explorer.exe C:\Dell, /e"
End Sub

- Jon