topic RE: How to open excel at predetermined time in Product Forum

How to open excel at predetermined time

HelariaShaningw — Mon, 01 Aug 2022 13:31:00 GMT

Hi Team

I am an Intern in Robotics department, i am working on the project of sending daily rates at specific times.
For example, sending rates via at 07h30, 11:30 etc.
How can i open at least one excel sheet for example at 7:30am everyday and save it as PDF?

Thank you in advance.

------------------------------
Helaria Shaningwa
------------------------------

RE: How to open excel at predetermined time

ewilson — Mon, 01 Aug 2022 14:55:00 GMT

Hello @Helaria Shaningwa,

Take a look at the Blue Prism Scheduler. That's the standard feature for launching a process at a specific time/day.

Blue Prism Scheduler

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: How to open excel at predetermined time

HelariaShaningw — Mon, 01 Aug 2022 15:24:00 GMT

Hello @Eric Wilson

Thank you.
But it seems like this is only done in control room, how i can do this in dev environment?
Even if the bot is scheduled to run for example at 07:30, how will it know which excel file to open if they are more than one excel files in the folder?
Can i not add a decision stage to check the time first before opening the file?

------------------------------
Helaria Shaningwa
------------------------------

RE: How to open excel at predetermined time

ewilson — Mon, 01 Aug 2022 16:24:00 GMT

@Helaria Shaningwa,

You would need to setup a local BP application server instance in your dev environment. Then you could make use of Scheduler locally. I have that as an option on my laptop, so it's not that difficult to set up.

Alternatively, you could use a combination of the local Windows Scheduler and the AutomateC.exe command line utility that's included with Blue Prism to perform this action. Basically you need to have a running instance of Automate.exe (this is the core process for a Digital Worker). You could launch this at startup, or you could have an entry in Windows Scheduler to start/stop the process. Then you would have an entry in Windows Scheduler to launch your process using AutomateC.exe. You would pass in the name of the process, your credentials, and any input parameters. The process would then be started on the local instance of Automate.exe that you already had running.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------