Load Windows Explorer
 

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.

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.

Load Windows Explorer
 

Hi raj;
Sub DirExplore()
With CreateObject("Shell.Application")
.Explore "C:\Mes Documents"
End With
End Sub

MP

"raj" a écrit dans le message de
...
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.

Load Windows Explorer
 

Shell "Explorer /n,/e,C:\Program Files"

"raj" wrote in message
...
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.