Excel

[TANGOACE]

Previously I posted regarding BA working with spreadsheets that were not excel. Since I have obtained a 1997 Excel to work with. I have since been able to link excel to BA however the bets do not trigger. When opening the Excel I receive a notice saying 'Compile Error Sub or function not defines' I press okay and then the spreadsheet will have the heading for the desired race from quick pick but in my case it only showed the favourite from this race together with a listing of runners from elsewhere. In the spreadsheet I am using the Multibot Version 1.6 a preset program you may be familiar with. I hope you can help and thank you for your attention.

[GeorgeUK]

Hi

Never heard of that multibot whatsit.
When you get the error message, does the VBEditor open up and highlight a section yellow?

It looks like the macro in the workbook you are using has an error in it.

If i had something like
Range("A1").value = Min(1, 2, 3)

If i put the formula "=min(1,2,3)" into a cell on the spreadsheet, it works fine, but in the code - excel does not know what min is. I would need to put worksheetfunction.min(1,2,3)

So i think there is something in the workbook code that is not being recognised.
Did you write the code, or was someone else selling this?
If they sold it to you, can you check that it was compatible with XL97?
(There are usually workarounds, but unless it's your code can be a real pain to try to work through everything)