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" ...
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" ...

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" ...

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.