Pivot table business object

[CR]

Does anyone know if there is an business object to manipulate pivot tables in Blue Prism?  I don't want to write VBA code. Thanks

[MelissaSuarez_G]

There isn't a Pivot Tables VBO. The only related action that I'm aware of if the ""Refresh All Pivot Tables"" on the Excel VBO

[Denis__Dennehy]

There are no VBO actions for what you ask.  In such instances it is up to you to create the VBO functionality yourself, there is a guide about how you do that: https://portal.blueprism.com/system/files/2017-11/Extending%20MS%20Excel%20VBO.PDF

[CR]

Thank you the guide was helpful. Will try to follow that.