Quote:
Originally Posted by Ray2000
I did this a few years back but it's a big pain in the ***
I never found a way to collect the charts, which are available for the current 2 weeks, automatically.
Had to get them manually one by one daily,
The Canadian charts are saved when the robot gets the wager results.
If the charts are saved as Excel file types "xls" then the macro in the attached file can parse the info to an Excel worksheet.
I have a version for Canada if wanted.
The macro in this workbook is sloppy at best, never cleaned it up.
It's just an example of parsing the charts. If you want to try it you'll need to change the file type to "xlsm"
Self interest use only!
|
Thank you Ray. This example helps me out. I'm working on pasting up a large PP type xml file. I'll get some ides on how to work a results table in there.
I'm not having the best of luck to use the xml file conversions. It's been like making a 7 layer cake. I can really mess it up. I'm going to keep tying.