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