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" 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
:

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

--
Tim Williams
Palo Alto, CA


"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

Much thanks

--
racud
-----------------------------------------------------------------------
racudd's Profile: http://www.excelforum.com/member.php...fo&userid=3350
View this thread: http://www.excelforum.com/showthread.php?threadid=56010