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.

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.

You can create aninstance of Internet Explorer as follows:

set ie= CreateObject("InternetExplorer.Application")

It has te following methods :

ExecWB, Navigate2, QueryStatusWB,ShowBrowserBar

and the following properties:

AddressBar,Offline, ReadyState,RegisterAsBrowser,RegisterAsDropTarget,
Resizable,Silent,TheaterMode

There are no events.


"Bob Phillips" wrote:

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.

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.

The OP asked about windows explorer and you responded with information on
Internet Explorer - were you suggesting Internet Explore as an
alternative/replacement for windows explorer?

--
Regards,
Tom Ogilvy

"AA2e72E" wrote in message
...
You can create aninstance of Internet Explorer as follows:

set ie= CreateObject("InternetExplorer.Application")

It has te following methods :

ExecWB, Navigate2, QueryStatusWB,ShowBrowserBar

and the following properties:

AddressBar,Offline, ReadyState,RegisterAsBrowser,RegisterAsDropTarget,
Resizable,Silent,TheaterMode

There are no events.


"Bob Phillips" wrote:

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.

Cheers

Unfortunately I want to work with Windows Explorer not Internet Explorer.

Dave F.


"AA2e72E" wrote in message
...
You can create aninstance of Internet Explorer as follows:

set ie= CreateObject("InternetExplorer.Application")

It has te following methods :

ExecWB, Navigate2, QueryStatusWB,ShowBrowserBar

and the following properties:

AddressBar,Offline, ReadyState,RegisterAsBrowser,RegisterAsDropTarget,
Resizable,Silent,TheaterMode

There are no events.


"Bob Phillips" wrote:

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.

As an alternative, perhaps:

ie.visible = true
ie.Navigate2 "c:\"


"Tom Ogilvy" wrote:

The OP asked about windows explorer and you responded with information on
Internet Explorer - were you suggesting Internet Explore as an
alternative/replacement for windows explorer?

--
Regards,
Tom Ogilvy

"AA2e72E" wrote in message
...
You can create aninstance of Internet Explorer as follows:

set ie= CreateObject("InternetExplorer.Application")

It has te following methods :

ExecWB, Navigate2, QueryStatusWB,ShowBrowserBar

and the following properties:

AddressBar,Offline, ReadyState,RegisterAsBrowser,RegisterAsDropTarget,
Resizable,Silent,TheaterMode

There are no events.


"Bob Phillips" wrote:

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.

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.

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.