VBA Excel in BA

[1856]

Hi Does anyone know if you can write VBA script within BA or only via a connection to excel?

Im wanting to simplify a trigger that places bets based on the current market book % and have 20 individual triggers trying to cover different market prices.

As always appreciate any advice.

Thanks
Michael

[Derek27]

Hi Does anyone know if you can write VBA script within BA or only via a connection to excel?

Im wanting to simplify a trigger that places bets based on the current market book % and have 20 individual triggers trying to cover different market prices.

As always appreciate any advice.

Thanks
Michael

VBA is a Microsoft product associated with the Office suite. BA doesn't actually have anything to do with VBA, it connects to Excel spreadsheets and writes data/reads instructions directly to/from the worksheet cells. VBA communicates with BA by writing to the cells, so you have to connect to Excel.

[1856]

Ok got it thanks, I might be using the wrong terminology ( VBA ) Can you write an IF type statement in BA?
Thanks

[ODPaul82]

You can do conditional statements which replicate IF & AND by using the start/end group of conditions in the rules editor

[Derek27]

...and you can replicate GOTOs by conditions/signals/rule with condition that fires when signal is set. There comes a level of complexity though, where it may be easier to write VBA subs.

[1856]

Ok thanks guys Im starting to understand more, I probably need to rethink this?

Appreciate all your suggestions.

Cheers
Michael