Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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!
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses