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...307856&sd=tech

Paul D

"racudd" wrote in
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...o&userid=33508
: View this thread: http://www.excelforum.com/showthread...hreadid=560105
: