Opening a windows folder

[LAS]

Hi all,

I want to pass a path to a procedure to get Excel to open a windows explorer folder.

It is not to select a file, and I do not require anything to be passed back to Excel. I just want windows explorer to open in that path.

Thanks

 

[SIXTH SENSE]

hi!
this opens awindows explorer at drive C

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Exporer()
Shell ("explorer c:\")
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[SIXTH SENSE]

or this one


<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Explorer()
Path = "c:\"
Shell ("explorer " & Path)
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[LAS]

Perfect

Thanks