Hi Gary/Mark,
I was trying your sample sheet with the getAllTradedVolume() function (http://www.gruss-software.co.uk/forum/v ... php?t=3726)
and everything works normal until I select a Market that is already closed. I get "Run-time error 13: Type mismatch" on VBA. Clicking in the "Debug" button this line of code is outlined:
For i = 0 To UBound(tradedVol)
After that If I select an open market from the "Quick pick list" the sample sheet doesn't work anymore, and the only solution is close and open excel again.
I remember using this sample spreadsheet a long time ago, using the same system I have now and this problem didn't exist.
(I'm using win7 x64, Excel 2010, Betting Assistant 1.1.0.66x77)
getAllTradedVolume() function
Moderator: 2020vision
5 posts
• Page 1 of 1
getAllTradedVolume() function
by bartolo » Thu Sep 15, 2011 6:53 pm
- bartolo
- Posts: 9
- Joined: Sat Jan 14, 2006 5:06 am
-
GaryRussell - Site Admin
- Posts: 9894
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
-
GaryRussell - Site Admin
- Posts: 9894
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
- bartolo
- Posts: 9
- Joined: Sat Jan 14, 2006 5:06 am
by GaryRussell » Fri Sep 30, 2011 7:55 am
The update has been released. See http://gruss-software.co.uk/forum/viewtopic.php?t=6583
-
GaryRussell - Site Admin
- Posts: 9894
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 48 guests