topic RE: Excel VBO - Creating Extra Code Stages in Digital Exchange

Excel VBO - Creating Extra Code Stages

john.hammond — Fri, 09 Sep 2022 08:13:00 GMT

Morning all.

I'm in need of formatting a range of cells within an Excel document - font type, size, unbolding etc. I can see that unbolding is an option on the Extended VBO, but not for amending the font. If I were to go about creating additional code stages to add this functionality (and bear in mind that I'm a complete novice with minimal coding experience in Python), is there some sort of guide that outlines the available functions, sub-routines and arguments that can be called? Or (and my fingers are very crossed here!), has somebody already made code stages that already add this functionality?

Cheers!

------------------------------
John Hammond
------------------------------

RE: Excel VBO - Creating Extra Code Stages

Mats__Pettersson — Fri, 09 Sep 2022 11:59:00 GMT

Hi John, creating your own actions with inspiration from the "Bold Font" action is doable.

For example, if you want to change the font, you can duplicate the action and add the following input: FontName

In the codestage, you map the input and pass it to the Font.Name code.

You can do this for all the font properties, see attached.

------------------------------
Mats Holm Pettersson
RPA Specialist
WillisTowersWatson
Europe/Copenhagen
------------------------------

RE: Excel VBO - Creating Extra Code Stages

john.hammond — Fri, 09 Sep 2022 12:45:00 GMT

Thank you Mats! I was trying to do similar to what you suggested but using the 'Format Cells in Range' action from the standard Excel VBO, but this made much more sense to me and was actually quite simple!

------------------------------
John Hammond
------------------------------

RE: Excel VBO - Creating Extra Code Stages

ManpreetKaur1 — Mon, 12 Sep 2022 20:08:00 GMT

Thanks @Mats__Pettersson for sharing the code stage. It's really helpful

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------