How do I work with excel files from VBO using utility MS Excel VBO?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-10-16 09:22 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-10-16 12:34 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-10-16 12:13 AM
Thank you so much Sufyan, it works!
Regards,
Nicole.
