Shell function for opening windows explorer

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?

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

--
Tim Williams
Palo Alto, CA


"racudd" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

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" <[email protected]> wrote in
message news:[email protected]...
:
: 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
:

Much thanks.