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.
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." <[email protected]> wrote in message
news:[email protected]...
> 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." <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> Dave,
>
> I would have thought that the window explorer does not support automation,
> so CreateObject is not an option.
>
> --
> HTH
>
> Bob Phillips
>
> "Dave F." <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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." <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
> news:[email protected]...
> > Dave,
> >
> > I would have thought that the window explorer does not support automation,
> > so CreateObject is not an option.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Dave F." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > Dave,
> > >
> > > I would have thought that the window explorer does not support
automation,
> > > so CreateObject is not an option.
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Dave F." <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > > >
> > > >
> > >
> > >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks