Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Windows Explorer | Excel Worksheet Functions | |||
When I double click an Excel file in Explorer, it does not load. | Excel Discussion (Misc queries) | |||
windows explorer to excel | Excel Discussion (Misc queries) | |||
Windows Explorer maximizes over XL 2000, if opened w/ explorer | Excel Discussion (Misc queries) | |||
Why does Windows Installer load | Setting up and Configuration of Excel |