VBA code for duplicating Excel Workbook

Closed
Pordm
Posts
1
Registration date
Friday February 12, 2016
Status
Member
Last seen
February 12, 2016
- Feb 12, 2016 at 12:27 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Feb 15, 2016 at 11:56 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
Feb 15, 2016 at 11:56 AM
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
0