View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shah shailesh shah shailesh is offline
external usenet poster
 
Posts: 78
Default Windows Explorer

Try this,

Shell "C:\WINDOWS\Explorer.exe /e,c:\Documents and Settings\default\My
Documents", vbNormalFocus


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.






"Launchnet" <u20911@uwe wrote in message news:74236ec4f180f@uwe...
I have the following Macro Code that I received from MH:

Shell "C:\WINDOWS\Explorer.exe /e,/select,c:\Documents and
Settings\default\
My Documents", vbNormalFocus

Works fine, but I need an additional step.

I want the "My Documents" folder to be open.

Thanks for the help in advance.

Matt@Launchnet

--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy
that
you read my story. God Bless for everyones help.