Betfair Data : Data-capture spreadsheet

sweetybt
Posts: 500
Joined: Sat Apr 18, 2009 4:35 pm

Tue Mar 04, 2014 8:17 pm

Totally agree, I discovered it on Friday and meant to write a post but got lost playing with it.

Well done Switesh.

Can't believe only 100 people have watched the video

chris_ri
Posts: 34
Joined: Wed Apr 15, 2009 1:57 pm

Wed Mar 05, 2014 9:46 pm

Hi Switesh,

Great spreadsheet!!

Im trying to run on 64bit Windows 7 today and I received the following error when I connect

Compile Error

The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with the PtrSafe attribute.

Wondered if you know what is needed, I cant be the first to run it on 64 bit windows.

Cheers,

Chris

switesh
Posts: 527
Joined: Mon Jul 11, 2011 8:43 am

Thu Mar 06, 2014 6:11 am

Thanks all for your kind & generous comments, & to Euler for the blog post.

Chris - I run it on Win 7, 64 bit, Excel 2010 laptop error free. I will however try to replicate your error and address it.

I assume it works fine for others?

chris_ri
Posts: 34
Joined: Wed Apr 15, 2009 1:57 pm

Thu Mar 06, 2014 1:08 pm

Thanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.

Replaced

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

with

Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

note the PtrSafe modifier.

Thanks again for the great spreadsheet.

Chris

User avatar
woodhousejj
Posts: 47
Joined: Thu Oct 24, 2013 11:19 pm

Thu Mar 06, 2014 1:26 pm

Thanks Chris I had the same mesaage, altough on one of the Windows forums it states that its not a problem so long as you don't want to amend the code.

John

gazuty
Posts: 1022
Joined: Sun Jun 26, 2011 11:03 am

Mon Mar 10, 2014 8:39 am

Switesh, what's with the closed sign over your profile?

buyshirts
Posts: 199
Joined: Sat Apr 18, 2009 12:37 pm

Mon Mar 10, 2014 5:09 pm

Cheers Thanks very much.
Top work very impressive.

User avatar
Naffman
Posts: 2321
Joined: Sun Aug 11, 2013 5:46 am

Sat Mar 15, 2014 10:26 pm

I think Switesh has left trading for good, unfortunate for a guy who put so much in to try and make it work!

gazuty
Posts: 1022
Joined: Sun Jun 26, 2011 11:03 am

Sun Mar 16, 2014 2:41 am

Naffman wrote:I think Switesh has left trading for good, unfortunate for a guy who put so much in to try and make it work!
Sorry to hear that. Hope he is otherwise ok.

PeterLe
Posts: 3325
Joined: Wed Apr 15, 2009 3:19 pm

Sun Mar 16, 2014 8:33 am

Ditto. If swiftest has left, he will be greatly missed.
I was reading a book last night where the author talked about how people quit when they are "3 foot from gold" ie they are literally just on the cusp of success.
Anyway if true (for whatever reason) all the very best Switesh

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest