Open, format, and save files sequentially - in Excel

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
riggy17
Newbie
Posts: 1
Joined: Fri Jan 26, 2018 11:47 pm

Open, format, and save files sequentially - in Excel

Post by riggy17 » Sat Jan 27, 2018 5:48 am

Hello, I am a new to Macro Scheduler and I am seeking assistance.
I would like to find a way to tell Macro Scheduler to open each of the following Excel files sequentially, so that I can format and save each as new files.

I feel fairly confident in the steps to format the files. The parts I would like assistance for are:
1. Open the first file… save as a new name
2. Open the second file… save as new name and so on…

Each file path is listed below:

C:\Users\R\Downloads\DONE\CK 3195806 2_16_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3301145 6_10_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3319233 7_1_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3338522 7_22_2016-S1.xlsx
C:\Users\R\Downloads\DONE\CK 3344453 7_29_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3357571 8_12_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3394366 9_23_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3400499 9_30_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3407494 10_7_2016-S1.xlsx
C:\Users\R\Downloads\DONE\Ck 3413931 10_14_2016-S1.xlsx

Kindest regards.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts