topic Re: Issue while using Close Workbook action of MS Excel VBO Extended in Digital Exchange

Issue while using Close Workbook action of MS Excel VBO Extended

VanithaK — Mon, 19 Aug 2024 14:50:11 GMT

Hi Team,

We have a bot which was developed in 2020 and was running fine till May 2024. We are having performance issue this month, where bot used to take average 2-2.3 minutes but now it is taking more than 4-5 mins to process tasks.

When we debug we found that bot is taking more time while saving workbook which it opens to check currency rates daily.

Can you please help us check this and improve the bot performance as early as possible.

We already raised #293601 ticket with Blue Prism support, but they asked to check in Community support

Thanks

Vanitha Kalshetty

Re: Issue while using Close Workbook action of MS Excel VBO Extended

Brigianakopec — Mon, 19 Aug 2024 18:22:51 GMT

Can you confirm you are using the latest VBO?

Re: Issue while using Close Workbook action of MS Excel VBO Extended

Nandhakumar — Tue, 20 Aug 2024 02:38:44 GMT

Hi @VanithaK ,

Are you using close workbook action with Save chages flag to true?

If yes, then i would suggest you to split save wb and close wb actions seperately. this helps you to have a re-try in case save fails for some strange reason.

Re: Issue while using Close Workbook action of MS Excel VBO Extended

VanithaK — Tue, 20 Aug 2024 06:24:01 GMT

Hi NandhaKumar,

We are running process on 2 different servers parallelly and they use same file at the same time. Earlier bot would not save these files separately but now from past 2 months bot is saving the file with server name tag. We don't know the reason of this peculiar behavior of the bot now. Earlier bot was fine.

Re: Issue while using Close Workbook action of MS Excel VBO Extended

Nandhakumar — Tue, 20 Aug 2024 07:04:39 GMT

@VanithaK , is it a read only file where bot just need to read the data and close it?

or it needs to update the values into the file?

can you provide us some screenshots of the actions used? because without save as code stage, bot will not save the file with different name.

Also bot runs in 2 runtime resources concurrently if i'm not wrong(you have mentioned it as server in above message)