Im currently writing a vba program to do with gambling. The problem i have is connecting to a workbook that is in use by another application. Im using a program called "Bet Angel" which links to an excell workbook and continuely updates odds. I then have another workbook which is my data sets and vba program to analyse these odds and then if applicable send some code back to the bet angel workbook to place a bet.
I have no problem getting values out of another workbook into mine but when The Bet Angel program is connected to the Workbook i end up getting a subscript out of range error. To me its like it becomes hidden once its connected to another program.
Bet Angel<------------>Bet Angel Workbook<--------------->My Workbook
Has anyone had this issue before or know any tips to get around this
Cheers
I have no problem getting values out of another workbook into mine but when The Bet Angel program is connected to the Workbook i end up getting a subscript out of range error. To me its like it becomes hidden once its connected to another program.
Bet Angel<------------>Bet Angel Workbook<--------------->My Workbook
Has anyone had this issue before or know any tips to get around this
Cheers
