can I enable function written in VBA in BO v5.1.6 ?

[redhair97]

hi there. hope someone uber clever can help..
I've written a rather complex piece of code in VBA to calculate an Option instrument value based on modified Black-Scholes model. I'd like to be able to call it in Business Objects by passing several input values, but am not succeeding so far - I can create and save function's code in VB but BO doesn't recognise it.. If I do the same using only BO variables - the report simply doesn't run because it's too much calculation going on so it's stalling - hence it needs to be external VBA code I think. If somebody can assist I'd be most grateful! thank you

 

[skrandel]

I have no idea how to do it, but you should do some research on how to make your VBA into a DLL and using it within BO.

I believe you can find out how to do this on BOB:

http://busobj.forumtopics.com

Steve Krandel
Intuit