Excel Add-Ins disappearing when opened from Blue Prism

[Anton Hosang]

So check all the Excel add-in/trust/macro settings are the same on the VDI as per test environment?
Can you run a simple macro on the remote VDI?? Like a Hello world macro?

 

[PrimePrism]

yes, a simple test macro works fine, but not with SAP commands

 

[PrimePrism]

I've added the SAP Analysis in the add-in section of Excel, added the location of the Excel file as the trusted location and also added the SAP Analysis Api in the references in VBA.

 

[sivagelli]

Another question- Can you login to the virtual machine and run macro manually? And you may check if the SAP Analysis API is showing up in the references section.

 

[PrimePrism]

yes, the macro works very well when logged in and run on the virtual machine. Even to run from Blue Prism, I've logged onto the virtual machine, but it still doesn't run from BP.

And, yes..SAP Analysis API is showing up in the references section.

Thanks

 

[PrimePrism]

one thing I noticed is that, Analysis and Analysis ToolPak - VBA add-ins appear in Active Application Add-ins section of Excel on the VDI. And, on the local machine these two appear in the Inactive Add-ins section.

 

[PrimePrism]

So, to make this work on the VDI, I had to set the references ATBVAEN and SAP Analysis API both and then it worked like magic !

Thanks everyone for your support.

 

[sivagelli]

Thanks for sharing the solution! Cheers!