Im new to Mac Express Pro.
I work in sports data.
I need to copy/paste from pages linked to this website page.
http://tatts.com/racing
I need to enter each individual race page (between 10 and 100 each day) - under the 'gallops' section - and copy the page, and paste to excel.
I see that there are potentially a number of different options one could use including window controls, capture, keyboard (pressing 'tab' does not seem to work on these webpages.)
I have not been able to find enough info on the tutorials etc.
What is the most efficient way to achieve this?
each page has a different url - eg . http://tatts.com/racing/2012/9/12/BR/1
Is there a way to automate this date/letter/number format?
- there are a limited variety which i could ask for each day and if not present could proceed to the next line?
Is vba code a possible option?
The website offers XML feed, but they don't seem willing/able to assist with my enquiries.
Any help will be much appreciated.