Can I use CreateObject for Windows Explorer?

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." <df@bh.cv.fg> wrote in message
news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> 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." <df@bh.cv.fg> wrote in message
> news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > 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" <phillips@tiscali.co.uk> wrote in message
news:e69ABIVVFHA.4056@TK2MSFTNGP15.phx.gbl...
> Dave,
>
> I would have thought that the window explorer does not support automation,
> so CreateObject is not an option.
>
> --
> HTH
>
> Bob Phillips
>
> "Dave F." <df@bh.cv.fg> wrote in message
> news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > 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" <AA2e72E@discussions.microsoft.com> wrote in message
news:32D8AC30-0D00-43F8-86DC-AF1BF55EE7F7@microsoft.com...
> 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." <df@bh.cv.fg> wrote in message
> > news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > > 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" <AA2e72E@discussions.microsoft.com> wrote in message
news:32D8AC30-0D00-43F8-86DC-AF1BF55EE7F7@microsoft.com...
> 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." <df@bh.cv.fg> wrote in message
> > news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > > 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" <AA2e72E@discussions.microsoft.com> wrote in message
> news:32D8AC30-0D00-43F8-86DC-AF1BF55EE7F7@microsoft.com...
> > 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." <df@bh.cv.fg> wrote in message
> > > news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > > > 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" <phillips@tiscali.co.uk> wrote in message
> news:e69ABIVVFHA.4056@TK2MSFTNGP15.phx.gbl...
> > Dave,
> >
> > I would have thought that the window explorer does not support automation,
> > so CreateObject is not an option.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Dave F." <df@bh.cv.fg> wrote in message
> > news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > > 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" <AA2e72E@discussions.microsoft.com> wrote in message
news:8F24A331-50A6-40A8-BEDA-2C6888F7B4D5@microsoft.com...
> 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" <phillips@tiscali.co.uk> wrote in message
> > news:e69ABIVVFHA.4056@TK2MSFTNGP15.phx.gbl...
> > > Dave,
> > >
> > > I would have thought that the window explorer does not support
automation,
> > > so CreateObject is not an option.
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Dave F." <df@bh.cv.fg> wrote in message
> > > news:OeSi1nUVFHA.2540@tk2msftngp13.phx.gbl...
> > > > 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.
> > > >
> > > >
> > >
> > >
> >
> >
> >