how to solve the difference between excel macro code and Excel VBO code in BP

[sameerasnd]

Hi,
I have tried to create new actions within Excel VBO business object by using of excel macro codes that runs properly in Excel itself. But there are several errors shows when check the code in code stage which extracted from the Excel macro. It is clear there were some code component of Excel macro need to replace when it apply to blue prism VBO.
So please guide me to fill up that gap between Excel Macro codes & VBO Code level. It will help me to do lot of automation based in Excel.

Thanks.

 

[gil.silva]

Hello,

The best way to understand Excel VBO is to check the existent actions and apply the same functions/methods to the new ones.
You can notice that Excel VBO has a huge Global Code in the Initialize page, which is huge to facilitate the creation of action.
So, you have functions like GetWorkbook(..) and so on.
The syntax used is VB.net, so you just need to check the Microsoft .Net documentation and apply to the Blue Prism existent library.