Betfair Price Files Download Manager -Collating the data

Post Reply
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

If you remember in the original video I created a 'UK Win 2008' folder. The attached spreadsheet collates that data into 1 workbook.

As I don't know what you have called your files, you'll have to change some of the code to suit.

Code: Select all

MyDir = "C:\UK Win 2008\"
would have to be changed to

Code: Select all

MyDir = "C:\UK Win 2009\"
to process the 2009 file.

Note:

1. I've copied the headers from the first 2008 csv file and pasted them into sheet 1
2. Not having looked at all the file types, I'm not sure if all of them have 17 columns of data.
3. If you do need to change, alter the code below to suit

Code: Select all

Set Rng = Range(.Cells(2, 1), .Cells(Rws, 17)
4. When it's running, the vba panel on the left should flash as it opens/closes each workbook. Camstudio doesn't show this and it looks very slow.
5. It doesn't keep track of what has / has not been collated, so maybe it's best if you just do an entire year at a time.


https://youtu.be/O0UriveLddE
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Betfair Data”