Shell function for opening windows explorer

[racudd]

Here's a basic question:
I'm using Shell "explorer", vbNormalFocus to open windows explorer, and
when explorer opens it is pointing toward My Documents. I would like
for it to point to My Computer instead, or possibly one of the other
drives. What do I need to add?

 

[PaulD]

Couple of options
temp = Shell("EXPLORER.EXE /n,/e,/select,C:\", vbNormalFocus)
will select C: on right but still have tree available on left

temp = Shell("EXPLORER.EXE /n,/e,/root,C:\", vbNormalFocus)
will force C to the root level of tree on left and show contents of C on
right

For more info on explorer switches check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;307856&sd=tech

Paul D

message :
: Here's a basic question:
: I'm using Shell "explorer", vbNormalFocus to open windows explorer, and
: when explorer opens it is pointing toward My Documents. I would like
: for it to point to My Computer instead, or possibly one of the other
: drives. What do I need to add?
:
:
: --
: racudd
: ------------------------------------------------------------------------
: racudd's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=33508
: View this thread: http://www.excelforum.com/showthread.php?threadid=560105
:

 

[Tim Williams]

http://support.microsoft.com/kb/q130510/

 

[racudd]

Much thanks