Call RFC enabled function from within VBA in BI 7.0

[Former Member]

Hello Experts,

the problem that we have should be general, i have found some postings on this forum concerning it, but unfortunately no proper solutiont.

I just want to have the possibility to call the rfc enabled function module from within the callback function in VBA after executing of some query.

I have seen the suggestion to build a new RFC connection in VBA, but therefore you should hard-code all connection parameters (including user + password)

in the VBA code, this solution is for us not acceptable due to the security reasons.

Is there some way to use the existing connection of BEx Analyser in order to execute the function calls?

This functionality was possible in 3.5 but not in 7.0 since many functions that were available in 3.5 are not supported now.

Do you have experience/suggestions for this problem?

Any help would be great.

Thanks a lot,

Kirill

[Former Member]

I've got the same problem. Did you find the solution?

Thank you,