shell explorer.exe

[misubud]

Hope this will be a quick fix for someone.
I am able to shell to explorer.exe, but i need it to open a specific directory.
ie on button click, open explorer.exe and open the folder of the current project.(ActiveWorkbook.path)

any assistance appreciated.

 

[pvw]

Hi

Just pass the path as parameter:
Shell "explorer " & ActiveWorkbook.Path

The code above shows the explorer with the folder view. If you want to see the 'real' explorer view (with the tree), use the '/e' parameter:
Shell "explorer /e, " & ActiveWorkbook.Path

HTH
Philipp

 

[misubud]

thanks!

worked a treat!

just have to remember it for next time