haydenk

Does MEP provide options on the software (i can't find it) to output to CSV? or does this need to written code?

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.