View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave F.[_4_] Dave F.[_4_] is offline
external usenet poster
 
Posts: 6
Default Can I use CreateObject for Windows Explorer?

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.