Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for replying,
Correct me if I'm wrong, but isn't that the same as (or v. similar to) doing: Shell "c:\winNT\explorer /n,/e, c:\ajay" Dave F. "AA2e72E" wrote in message ... Alternatively, try: Sub aa() Set xx = CreateObject("WScript.Shell") xx.Exec "EXPLORER.EXE c:\ajay" Set xx = Nothing End Sub "Dave F." wrote: Thanks for replying What programs do support automation? Is it only those that have VBA built into them? or are there other ways to interact with them? Cheers Dave F. "Bob Phillips" wrote in message ... Dave, I would have thought that the window explorer does not support automation, so CreateObject is not an option. -- HTH Bob Phillips "Dave F." wrote in message ... Hi I'm using VBA At the moment to open windows explorer I'm using: Shell "c:\winNT\explorer /n,/e," Is there a way to use CreateObject? Would that be a better way or is Shell as good as it gets? Thanks Dave F. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Windows Explorer | Excel Worksheet Functions | |||
Windows Explorer maximizes over XL 2000, if opened w/ explorer | Excel Discussion (Misc queries) | |||
Windows Explorer Question | Excel Programming | |||
Use Windows Script to run Windows Explorer Search? | Excel Programming | |||
Load Windows Explorer | Excel Programming |