VBA code for duplicating Excel Workbook [Closed]

Report
Posts
1
Registration date
Friday February 12, 2016
Status
Member
Last seen
February 12, 2016
-
Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
-
Hi all!

My company use delay logs where we record delays everyday for different customers.

At the moment every morning we're having to manually save new workbook everyday, which takes some time when there's around 30 accounts.

Is there a macro i can create that automatically generate a new workbook everyday with the days date?

My current file name is something like 'ESPN delays 12/02/2016' so i'd need the file name changing each day.

Thanks!

1 reply

Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
446
Hi Pordm,

Let me see if I get this right.

You want a macro that duplicates the workbook 'ESPN delays 12/02/2016' and then change the name according today's date. So if the macro were to run today the name would be 'ESPN delays 15/02/2016'.

But how about those 30 accounts? Where do they fit in?

Best regards,
Trowa