Hi Team,Hope you are doing good.
As a part of our process, it involves saving a large excel macro enabled file (around 40 MB). I tried the below options but the issue still remains. It still giver error
Could you please help me out on this, this is pretty urgent.Let me know if you need more information.
Hi Wing, Well so I am opening the file from a shard drive, doing some data manipulation using macros and generating a report. At the end I am trying to save the file in the same folder using MS Excel VBO (Save action). Initially I was getting time out error. But the issue still remains after increasing the wait time as well. This time it gives some system error.
Of the options you mentioned you've tried, where are you setting the timeouts in the code stage?
I was changing the time out in action stage after opening from object studio Have you tried running through the same operations with a smaller Excel file? Yes I did and it was working fine How many rows of data is in the file?Well depends.it has got close to 20 sheets each includes around 300, 400 rows of data How long does the normal Save action take if done manually by a human?normally it takes close to 120 secs to save the workbook Feel free to reach me if you have any questions Appreciate your help
NEW TO RPA?
What is Connected-RPA?
Intelligent RPA Platform
Why Blue Prism?
Contact the Community Team
Blue Prism DX
Privacy & Cookies
Terms of Service
© Blue Prism