I'm writing a macro to copy data to and from a web page using mainly the send
keys function. Currently I have set a long wait period in the code while the
site updates. This not only makes the macro run slower than it needs to but
also cannot detect if the site crashes.

Does anyone know a way i can check the state of the site and detect a
change. Eg when the site move from account search to account information.

Why automate IE ?
Here's 1 example :
http://support.microsoft.com/kb/167658

NickHK

"Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
> I'm writing a macro to copy data to and from a web page using mainly the
> send
> keys function. Currently I have set a long wait period in the code while
> the
> site updates. This not only makes the macro run slower than it needs to
> but
> also cannot detect if the site crashes.
>
> Does anyone know a way i can check the state of the site and detect a
> change. Eg when the site move from account search to account information.

While automating IE should work I am limited in the way I can access the site
because of company policy. I need to find a way to find out when the site
has loaded the second page.

"NickHK" wrote:

> Why automate IE ?
> Here's 1 example :
> http://support.microsoft.com/kb/167658
>
> NickHK
>
> "Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
> > I'm writing a macro to copy data to and from a web page using mainly the
> > send
> > keys function. Currently I have set a long wait period in the code while
> > the
> > site updates. This not only makes the macro run slower than it needs to
> > but
> > also cannot detect if the site crashes.
> >
> > Does anyone know a way i can check the state of the site and detect a
> > change. Eg when the site move from account search to account information.
>
>
>

Does that mean you cannot automate IE ?

Or you can talk directly to the server.

NickHK

"Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:947ABC93-2261-492F-AAEB-(E-Mail Removed)...
> While automating IE should work I am limited in the way I can access the
> site
> because of company policy. I need to find a way to find out when the site
> has loaded the second page.
>
> "NickHK" wrote:
>
>> Why automate IE ?
>> Here's 1 example :
>> http://support.microsoft.com/kb/167658
>>
>> NickHK
>>
>> "Ash" <(E-Mail Removed)> ???gco?l¢Do¡Ps?D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
>>
>> > I'm writing a macro to copy data to and from a web page using mainly
>> > the
>> > send
>> > keys function. Currently I have set a long wait period in the code
>> > while
>> > the
>> > site updates. This not only makes the macro run slower than it needs
>> > to
>> > but
>> > also cannot detect if the site crashes.
>> >
>> > Does anyone know a way i can check the state of the site and detect a
>> > change. Eg when the site move from account search to account
>> > information.
>>
>>
>>

I can do very little. I am restricted to beed able to use send keys to
select a textbox on the site and goto the enter button. after that It using
send keys again to select information.

"NickHK" wrote:

> Does that mean you cannot automate IE ?
>
> Or you can talk directly to the server.
>
> NickHK
>
> "Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:947ABC93-2261-492F-AAEB-(E-Mail Removed)...
> > While automating IE should work I am limited in the way I can access the
> > site
> > because of company policy. I need to find a way to find out when the site
> > has loaded the second page.
> >
> > "NickHK" wrote:
> >
> >> Why automate IE ?
> >> Here's 1 example :
> >> http://support.microsoft.com/kb/167658
> >>
> >> NickHK
> >>
> >> "Ash" <(E-Mail Removed)> ???gco?l¢Do¡Ps?D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
> >>
> >> > I'm writing a macro to copy data to and from a web page using mainly
> >> > the
> >> > send
> >> > keys function. Currently I have set a long wait period in the code
> >> > while
> >> > the
> >> > site updates. This not only makes the macro run slower than it needs
> >> > to
> >> > but
> >> > also cannot detect if the site crashes.
> >> >
> >> > Does anyone know a way i can check the state of the site and detect a
> >> > change. Eg when the site move from account search to account
> >> > information.
> >>
> >>
> >>
>
>
>

If you can ONLY use SendKeys as a requirements, then it seems you in for
alot of trouble every time there is a small layout change in the controls on
the pages etc.
Good luck.

And I suppose an Excel web query is out of the question ?

NickHK

"Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:7C718914-0B07-4692-9047-(E-Mail Removed)...
>I can do very little. I am restricted to beed able to use send keys to
> select a textbox on the site and goto the enter button. after that It
> using
> send keys again to select information.
>
> "NickHK" wrote:
>
>> Does that mean you cannot automate IE ?
>>
>> Or you can talk directly to the server.
>>
>> NickHK
>>
>> "Ash" <(E-Mail Removed)> ???gco?l¢Do¡Ps?D:947ABC93-2261-492F-AAEB-(E-Mail Removed)...
>>
>> > While automating IE should work I am limited in the way I can access
>> > the
>> > site
>> > because of company policy. I need to find a way to find out when the
>> > site
>> > has loaded the second page.
>> >
>> > "NickHK" wrote:
>> >
>> >> Why automate IE ?
>> >> Here's 1 example :
>> >> http://support.microsoft.com/kb/167658
>> >>
>> >> NickHK
>> >>
>> >> "Ash" <(E-Mail Removed)> ???gco?l¢FDo!Ps?D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
>> >>
>> >> > I'm writing a macro to copy data to and from a web page using mainly
>> >> > the
>> >> > send
>> >> > keys function. Currently I have set a long wait period in the code
>> >> > while
>> >> > the
>> >> > site updates. This not only makes the macro run slower than it
>> >> > needs
>> >> > to
>> >> > but
>> >> > also cannot detect if the site crashes.
>> >> >
>> >> > Does anyone know a way i can check the state of the site and detect
>> >> > a
>> >> > change. Eg when the site move from account search to account
>> >> > information.
>> >>
>> >>
>> >>
>>
>>
>>

It's been interesting. I've got everytthing working perfect apart from when
the web based system is running sluggish and the wait time I have for a web
page isn't long enough.

"NickHK" wrote:

> If you can ONLY use SendKeys as a requirements, then it seems you in for
> alot of trouble every time there is a small layout change in the controls on
> the pages etc.
> Good luck.
>
> And I suppose an Excel web query is out of the question ?
>
> NickHK
>
> "Ash" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:7C718914-0B07-4692-9047-(E-Mail Removed)...
> >I can do very little. I am restricted to beed able to use send keys to
> > select a textbox on the site and goto the enter button. after that It
> > using
> > send keys again to select information.
> >
> > "NickHK" wrote:
> >
> >> Does that mean you cannot automate IE ?
> >>
> >> Or you can talk directly to the server.
> >>
> >> NickHK
> >>
> >> "Ash" <(E-Mail Removed)> ???gco?l¢Do¡Ps?D:947ABC93-2261-492F-AAEB-(E-Mail Removed)...
> >>
> >> > While automating IE should work I am limited in the way I can access
> >> > the
> >> > site
> >> > because of company policy. I need to find a way to find out when the
> >> > site
> >> > has loaded the second page.
> >> >
> >> > "NickHK" wrote:
> >> >
> >> >> Why automate IE ?
> >> >> Here's 1 example :
> >> >> http://support.microsoft.com/kb/167658
> >> >>
> >> >> NickHK
> >> >>
> >> >> "Ash" <(E-Mail Removed)> ???gco?l¢FDo!Ps?D:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
> >> >>
> >> >> > I'm writing a macro to copy data to and from a web page using mainly
> >> >> > the
> >> >> > send
> >> >> > keys function. Currently I have set a long wait period in the code
> >> >> > while
> >> >> > the
> >> >> > site updates. This not only makes the macro run slower than it
> >> >> > needs
> >> >> > to
> >> >> > but
> >> >> > also cannot detect if the site crashes.
> >> >> >
> >> >> > Does anyone know a way i can check the state of the site and detect
> >> >> > a
> >> >> > change. Eg when the site move from account search to account
> >> >> > information.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Ash wrote:
> I'm writing a macro to copy data to and from a web page using mainly the send
> keys function. Currently I have set a long wait period in the code while the
> site updates. This not only makes the macro run slower than it needs to but
> also cannot detect if the site crashes.
>
> Does anyone know a way i can check the state of the site and detect a
> change. Eg when the site move from account search to account information.

It sounds like you are using SENDKEY (ugh!) to enter info on a web
page, click enter or some similar button and then a new web page
appears. If you are trying to detect when this new page is fully
loaded, insert something like the following loop in your code...Ron

Do Until .ReadyState = READYSTATE_COMPLETE And Not .Busy
DoEvents
Loop

Not sure if this helps but I use this to wait for a response, I have in the
past also used the OnTime function to time this out if needed.

Sub WebLink()
Set ie = CreateObject("InternetExplorer.Application")

sURL = "http://www.yourpage.com"

ie.Navigate sURL

'wait for response
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

ie.Visible = True

ie.Quit
Set ie = Nothing

End Sub


--
Cheers
Nigel



"Ash" <(E-Mail Removed)> wrote in message
news:6C57A21B-AF89-497F-8964-(E-Mail Removed)...
> I'm writing a macro to copy data to and from a web page using mainly the
> send
> keys function. Currently I have set a long wait period in the code while
> the
> site updates. This not only makes the macro run slower than it needs to
> but
> also cannot detect if the site crashes.
>
> Does anyone know a way i can check the state of the site and detect a
> change. Eg when the site move from account search to account information.

You can also try SWExplorerAutomation SWEA (http://webunittesting.com).
SWEA makes IE automation a very simple task.

Ash wrote:
> I'm writing a macro to copy data to and from a web page using mainly the send
> keys function. Currently I have set a long wait period in the code while the
> site updates. This not only makes the macro run slower than it needs to but
> also cannot detect if the site crashes.
>
> Does anyone know a way i can check the state of the site and detect a
> change. Eg when the site move from account search to account information.