I have added some VB macros into the basic multiple spreadsheet.
It is now saved as an xlsm format (instead of the usual xls).
Bet Angel does not seem to accept spreadsheets in this format. Is there any reason for this?
I assume I need to get some converter to ensure all my macros work.
XLSM Files
Hi seal
I have adapted the BetAngel_1 spreadsheet with macros and saved in xlsm format. Excel integration seems to work very well although initially I had a few errors because excel 2010 seems to be less forgiving in terms of VBA code than 2003. The main change I had to make was nesting my code between
Application.EnableEvents=False and Application.EnableEvents=True
where the code was updating values in the sheet. This prevents the event handler functions such as Calculate from being triggered when the sheet is updated from Betangel.
I have adapted the BetAngel_1 spreadsheet with macros and saved in xlsm format. Excel integration seems to work very well although initially I had a few errors because excel 2010 seems to be less forgiving in terms of VBA code than 2003. The main change I had to make was nesting my code between
Application.EnableEvents=False and Application.EnableEvents=True
where the code was updating values in the sheet. This prevents the event handler functions such as Calculate from being triggered when the sheet is updated from Betangel.