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.