How to call windows explorer from a macro in excel

[Guest_imported]

I'm doing a macro in excel 2000, and I'd been looking how to call windows explorer with a specified route, but i couldn't find it, if someone can help, i will apreciatte .

Thanks.

 

[MoonMullen]

cesar_soto -

What I have done is as follows;
'
Sub RunExplorer()
Dim RetVal As Double
RetVal = Shell("C:\WINDOWS\EXPLORER.EXE /n,/e,C:\", 1)
End Sub

I am currently running Excel97. You would have to find out where your EXPLORER.EXE program is on your hard drive and then change your path for the one I have coded above. It should work.

 

[Guest_imported]

Thanks for the tip, that really helps me, but i wonder if you know a way to call a specific direction after opened windows explorer:

Sample:
I want to see the folder: \\server\tecnology\new
through Macros ???