Excel VBA automatic fill and submit web forms from excel data

Hi,

Blow code works fine when using F8 key clik step by step, but run key doesn't. what i need to add below code? Please watch youtube link below to better understand question.
Thanks for advance.

https://youtu.be/zxL5GlhG0iA

Please Login or Register  to view this content.

Hi there,

Try relocating the "Do Until .readystate = 4" statement as follows and see if it does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Originally Posted by Greg M

Hi there,

Try relocating the "Do Until .readystate = 4" statement as follows and see if it does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks for reply.
I have tried relocating. But still doesn't Work.

Hi again,

It's difficult for me to test what you're trying to achieve, but see if the following code gets you moving in the right direction:

Please Login or Register  to view this content.

Please note that if I include your original (i.e. accented) text as the string to be located, my post will not be displayed here - for this reason I have replaced the text string with "Insert Your text Here".


Hope this helps - please let me know how you get on.

Regards,

Greg M

Greg thanks for your reply, below code also works fine. But I come across another popup messages problem. When below code riches .all("now_pay").click will appears popUP menu with OK button. I have to manually click to continue each time. Below link you can find print screen of web site. Website url could access only with our companies computers. What we should add to pass away that popup message or just click aromatically by codes ok button.


1. Gif file linkhttps://drive.google.com/open?id=0B8...RJbWtEb1V0b1Zj
2. Video link https://drive.google.com/open?id=0B8...Z6VXoxUjlaOWRV

Please Login or Register  to view this content.

Here is HTML code link : https://drive.google.com/open?id=0B8...ZHaVlwZFBjd1U0

Hi again,

Sorry for the delay in replying.

I'm afraid that my knowledge of interacting with HTML code is very limited - I don't know how to implement repeated clicking on a webpage button

Regards,

Greg M