Hi Guys

I would like help to create a Macro that looks at an Excel Spreadsheet.

Accomplishes

1/ Logging into NZ TAB using A1 (User name) and A2 (Password)
2/ Looks at Cells B2 (Horse Number) and B2 ($ Bet Amount) and enters Values into appropriate box's on Web Page
3/ Then completes the Submit process

That's it.

I have found Code that fills in Username and Password for

https://www.tab.co.nz/racing/?action=schedule#

Bit clunky but the only one I could find that actually works, message box's disappear after 1 second but sometimes on first call I need to click 1st one, sure there's a better code.

And still can't get it to Actually Login "Click" / "Submit".

Things to look at

A/ Clicking correct Radio Button for selected horse B2 (Horse Number)

B/ Clicking Win or Place

C/ Entering Bet Amount in Bet Amount box B2 ($ Bet Amount)

D/ Clicking Login

E/ Clicking Submit Bet

8/ Clicking the final "OK"

I think that's about it

All that is needed is Tenacity knowledge and Skill : )

I will of course help where I can

One may need a NZ TAB account really, to go through whole process.

Regards

Mike

Attached Files

TAB_ User Name _ Password.xlsm (20.0 KB, 1542 views)