SAP BO Analysis for Office by VB Script

[Former Member]

Hi All,

I need to open a SP BO Analysis for Office file through VB Script. If I am using the "CreateObject("Excel.Application")" then it will open only the file not the ADD IN of Excel Analysis and the Data Source is not getting refreshed.

Is there any other command to open the file with Analysis Add IN.

Regards,

Arindom

[former_member110741 · Accepted solution]

Hi Arindom Saha,

Did you try changing LoadBehavior parameter to 3 in registry settings

Subhash

[Former Member · Accepted solution]

Hi Subhash,

I am using MS Office 2013. Can you please describe the path to get LoadBehavior parameter.

Arindom

[former_member110741 · Accepted solution]

HI,

go to below path change Loadbahavior to 3

Subhash

[Former Member]

Or here a solution with VBA:

[Former Member]

Thanks.let me try Victor.

Arindom