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
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!
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:
- VBA code for duplicating Excel Workbook
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Cs 1.6 code - Guide
- Usa country code for whatsapp - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 15, 2016 at 11:56 AM
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
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