InvictusSol
New Member
- Joined
- Jan 5, 2016
- Messages
- 15
I'm trying to automate a task of copying/pasting tables from the web into MS Excel. I thought Macro/VBA code would be fairly simple to grasp (as I thought the task was fairly basic), but alas hours later I'm still left scratching my head.
The web address is as follows: Trackinfo -Search for greyhounds - view their history
The tables returned ARE ALWAYS nine (9) columns in width, but will be variable in rows/length from 1 or 2 rows up to maybe 15 rows.
I'd like to LOOP through all the records, ie 60000, 60001, 60002, 60003 etc (in the web address where "keyword=60000") and paste a 9x10 table in a worksheet, then a 9x12 table in the next available/free/empty row below it, then a 9x4 table below that etc etc etc.
If this is (as I suspect) a five minute/12-15 rows of code task I'd be extremely thankful for any help, otherwise if I could be pushed in the right direction via some SPECIFIC keyword search or a link to a relevant tutorial, I'd be appreciative as well.
Thanks
The web address is as follows: Trackinfo -Search for greyhounds - view their history
The tables returned ARE ALWAYS nine (9) columns in width, but will be variable in rows/length from 1 or 2 rows up to maybe 15 rows.
I'd like to LOOP through all the records, ie 60000, 60001, 60002, 60003 etc (in the web address where "keyword=60000") and paste a 9x10 table in a worksheet, then a 9x12 table in the next available/free/empty row below it, then a 9x4 table below that etc etc etc.
If this is (as I suspect) a five minute/12-15 rows of code task I'd be extremely thankful for any help, otherwise if I could be pushed in the right direction via some SPECIFIC keyword search or a link to a relevant tutorial, I'd be appreciative as well.
Thanks