Load Windows Explorer

  • Thread starter Thread starter raj
  • Start date Start date
R

raj

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.
 
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]
 
Hi raj;
Sub DirExplore()
With CreateObject("Shell.Application")
.Explore "C:\Mes Documents"
End With
End Sub

MP
 
Back
Top