doriannjeshi
Active Member
- Joined
- Apr 5, 2015
- Messages
- 338
- Office Version
- 365
- Platform
- Windows
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 ?
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 ?