topic Re: Excel VBO - Format Range not working in Digital Exchange

Excel VBO - Format Range not working

Automations — Fri, 25 Jul 2025 08:41:47 GMT

Have got the latest excel VBO and trying to format range, but it is not working due an error on the "activate workbook page" not finding the handle provided.

Assuming this is a bug within the code stage rather than anything else ?

Re: Excel VBO - Format Range not working

GeoffHirst — Fri, 25 Jul 2025 10:45:41 GMT

Hi @Automations

Thank you for being an SS&C Blue Prism customer, and for using Blue Prism.

Sorry to hear you are having difficulty with this asset. As this was an issue I haven't seen anyone raise before I created an example for Format Range in the demonstration process. I will update this document and make it available later.

I took a very simple document of 5 lines and placed a currency numeric format on a few numbers. The formatting worked fine and it reported no problems.

My suggestion to you is could you post a screenshot of your process and detail the parameter values you have provided for the action. From there we may be able to assist you further.

regards

Re: Excel VBO - Format Range not working

Automations — Fri, 25 Jul 2025 11:04:19 GMT

Thank you for your swift response, we've since found another method which seems to have worked, and can now (unhelpfully for this thread) cannot now replicate the error we found.

Apologies from our end, but we'll comment again should we be able to replicate in future.

Re: Excel VBO - Format Range not working

GeoffHirst — Fri, 25 Jul 2025 11:42:02 GMT

Hi @Automations

That's great news that you have found yourselves a solution.

Any more issues, just come back here and we will help where we can.

Thanks for using Blue Prism.

regards