cancel
Showing results for 
Search instead for 
Did you mean: 

How do I work with excel files from VBO using utility MS Excel VBO?

n_madariaga_ber
Level 2
I have tried to use the MS Excel VBO utility, but I'm just learning the use of Blue Prism and I can not use this utility. How to access the utility, that's my question, what element of the VBO? Thank you
2 REPLIES 2

sufyans
Level 3
Hi n.madaraiga,bernal, To install the Excel VBO, in Blueprism menu, click File –> Import and then select the BPA Object - MS Excel.xml file from the VBO directory in Blueprism program files folder. C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO\. You can make use of this imported VBO by creating a new object and adding an Action stage. Double click on Action stage and select MS Excel VBO as the object, and respective action along with specified input and output parameters. You will have to try and experiment them yourself. Below are some commonly used actions of the VBO. 1. Create instance - Starts an Excel session. 2. Open workbook - Opens specified workbook. 3. Show workbook - Shows the workbook on screen. etc.... Regards, Sufyan.

Thank you so much Sufyan, it works! Regards, Nicole.