Question: I just completed an RPA pilot with UiPath. The bot gets an email, logs in to our Web ERP, downloads a bunch of reports, and final step is to update Excel formulas and models (vlookups etc.) and send email User keyboard time of 2 hours now shrunk down to 0 hours. The bot is running on a vm 24/7 waiting on the email. Interestingly, the bot does everything well but fails on the final step of updating Excel models. If someone is logged into the VM, no errors and completes the work. Help?

like
Posting as :
works at
You are currently posting as works at

How do you trigger the model update? (Activity)

like

The reports get downloaded from our ERP. When the last report gets downloaded and the ERP shows a Done status, the bot knows to close the web browser and go to the folder where the reports are saved. This is where the bot starts updating excel formulas.

Convert the excel process to a macro and execute the macro instead of keying the formulas

Keying formulas almost always causes issues in excel... make it a macro and it will be completely fine

Few questions: 1. Which edition of uipath you are using ? Community or enterprise ? 2. Are you using excel application scope to perform these actions ?

1. Community. Is there a difference? 2. Excel app scope? What do you mean?

Additional Posts

If you’ve been at the same client b/c you’re constantly winning work there, does it help when it comes time for promotion? I heard it’s generally the fast track to a promo but not sure if it’s true.

like

Hi all Question for those at BCG and McKinsey. How is Associate Partner at McKinsey different from Principal at BCG ? -Responsibilities -Comp -etc

like

If you had an offer from another company, what percent increase in salary would you need to accept the offer? (Ex: 15% above current salary)

like

Is it easier/harder to recruit for mckinsey implementation vs a generalist role for mba full time recruiting? I kinda like ops work, but wondering if there's any issues with supply & demand re: hiring.

like

What’s the agency producer contractor day rate for chicago?

like

Anyone selling 10k bonvoy points? I will pay $75

like

Curious to know the compensation range for positions at the EY delivery centers? Do all new grads start around 40k? Which roles get paid the most there?

like

Hey, how to prepare for case interviews? Too many times I’ve been told I lack critical thinking.

like

Can I apply for the same department my wife works in? Or would that be conflict of interest? She works for a big 4

like

Are you allowed to intern at Big 4 while also working another job?

like

Looking to jump to Microsoft but the recruiters I have reached out to have been pretty quiet lately and haven't said much about an.interviee..in the cyber space, lots of experience, clearances, they just aren't interested, normally take a long time to respond (been a couple of weeks), are they slowing down hiring, other? Thanks

like

I got recruited for an in house position...3 months pregnant. I know I am not guaranteed parental leave, what are the pros/cons of telling the interviewer about my condition?

like

Hi fishes! Does slalom offer any tuition reimbursement for grad school?

like

ZS vs. Slalom? Money is very similar for roles at both with focus on LS compliance so just asking for a sense of culture and WLB

like

just joined the firm and needed to roll over my 401k. I got a check from the old brokerage made out to the new brokerage for the value of my 401k. Still haven’t sent it in to PwC. Should I hold off

like

I recently heard a client talking about the sex wage gap as if it were real. I declined to engage since I didn't want to irritate the client. However, I thought this had been conclusively dispelled? There is no statistical disparity in pay for the same work between the sexes right? How do you correct this fallacy with a client? Is it worth it?

like

Know you travel too much when you can judge the status of the SPG integration by the now matching granola in Marriott and SPG.

like

Anyone been to cuba recently? Any watchouts from an immigration point of view. Planning to travel mid july

Senior up for promo to manager in audit in next year. Have decided I do not want to be an auditor. Which of these paths do you think is best? 1. Stay 1 more year, exit to industry with manager title. 2. Move to advisory internally, but most likely would have to do one more year in audit and move as audit manager to advisory sr 3. Exit immediately into industry to try for accounting manager title / senior accountant or sr fin analyst 4. Exit immediately to advisory senior at another big 4 firm

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.