Macro script and scheduler

[doriannjeshi]

Hello,

I need to fully automate a process which consists of getting data , copy paste, from 2 excel files , in a 3d. Then running a macro (which I already have recorded ) from this 3d excel file.
This macro calculates the data that got pasted and generates a new a book that gets saved and sends it via email.

The names of the 2 excels files are: number+ name of the report, i.e date_rpt_1 and date_rpt_2, because they get generated from a program daily
third excel file is named exlfile3

The part that I want to automate with a scheduler thus with a script batch file:
1. Open the 3 excel files: date_pt_1 , date_rpt_2 and exlfile3
2. Copy and paste the data from the 2 excel files onto the third. date_pt_1 sheet1 content needs to be pasted on sheet2 of exlfile3, and date_rpt_2 sheet1 needs to be pasted on sheet3 of exlfile3
3. Run the macro already present in exlfile3 , named macro1
4. Send the final file created with current date from macro1 via email


is it possible to do this fully automatically ?

 

[Micron]

Look into Windows Task Scheduler. I believe that for this to work, the pc where this is set up has to be running at least. Not sure about any user log ins. We had a dedicated desktop pc with its own profile that we never shut off and IT never rebooted so it was pretty reliable on a daily basis.