Update to MS Excel VBO Posted

ewilson — Wed, 13 Apr 2022 17:08:00 GMT

All,

An update has been posted to the Digital Exchange for the MS Excel VBO. The new version is 6.10.4. You can find it at the following link:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

The new version includes the following 3 new actions:

Autocalculate
- Provides the ability to disable/enable the Auto Calculation feature of Excel. This can be used in cases where you experience issues with calculations in large workbooks causing things to slow down when you update cell(s) linked to those calculations.
Format Range
- The VBO has had actions for formatting individual cells, but this action will allow you to change the formatting of a range of cells (ex. an entire column).
Text to Columns
- This action can be used to take the contents of a single column, where the cells contain delimited data, and expand that delimited data to multiple columns. As an example, the following column of comma delimited data could be parsed and expanded to two columns (Last Name and First Name).

Before

After

#Excel #VBO

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Update to MS Excel VBO Posted

lookman — Thu, 14 Apr 2022 13:38:00 GMT

Thanks Eric for the update.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

topic RE: Update to MS Excel VBO Posted in Digital Exchange

Update to MS Excel VBO Posted

RE: Update to MS Excel VBO Posted