#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Windows Explorer

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 47
Default Windows Explorer

Works fine.
Thanks for the great help and fast response.
Matt@Launchnet

shah shailesh wrote:
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.

I have the following Macro Code that I received from MH:

[quoted text clipped - 9 lines]

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.

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlling windows explorer with VB macro gauss1976 Excel Discussion (Misc queries) 0 July 27th 06 09:30 AM
Opening Excel workbooks from Windows Explorer R Ormerod Excel Discussion (Misc queries) 2 April 1st 06 12:44 PM
windows explorer to excel barrfly Excel Discussion (Misc queries) 2 July 27th 05 04:28 PM
Windows Explorer maximizes over XL 2000, if opened w/ explorer bill Excel Discussion (Misc queries) 2 June 28th 05 02:53 PM
search by date in windows explorer boyd Excel Discussion (Misc queries) 3 May 25th 05 05:14 AM


All times are GMT +1. The time now is 03:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"