View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Load Windows Explorer

Hi raj,

Here's one way to do it:

Sub ExploreCDrive()
Dim sh As Shell32.Shell

Set sh = New Shell32.Shell
sh.Explore "c:\"
Set sh = Nothing
End Sub

To execute this, you need to set a reference to "Microsoft Shell Controls
and Automation" via Tools | References. I'm not sure what OSes the library
is included with.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


raj wrote:
Hello, please help.

What is the easiest method to open a new instance of
Windows Explorer and have it display a certain subfolder
with a split screen (i.e. folders on left/files & file
details on right)?

Your example code would be most helpful, thanks.