Hi Gurus,
I have been browsing to find a solution but none have specifically fit the criteria I need and what testing I have done has failed.
I am attempting to leave a workbook I created years ago in the hands of those far less familiar with Excel and even less familiar with VBA and I just need to finalize it by creating a module that when executed will copy the workbook and rename it with the next year at the end of the title and preserve all VBA that I have been manually importing every year.
I just want to leave this so that at the end of the year, a user may open the December sheet and click on a button and it will copy the workbook/worksheets, clear all data on the month sheets (except the header in A1) and import VBA from the source workbook and finally rename the new workbook to Rx Monthly 2019 with the same .xlsm extension.
Workbook is named Rx Monthly 2018 with .xlsm extension. Workbook has sheets for each month and an additional sheet for static information.
Thanks in advance,
Natep
I have been browsing to find a solution but none have specifically fit the criteria I need and what testing I have done has failed.
I am attempting to leave a workbook I created years ago in the hands of those far less familiar with Excel and even less familiar with VBA and I just need to finalize it by creating a module that when executed will copy the workbook and rename it with the next year at the end of the title and preserve all VBA that I have been manually importing every year.
I just want to leave this so that at the end of the year, a user may open the December sheet and click on a button and it will copy the workbook/worksheets, clear all data on the month sheets (except the header in A1) and import VBA from the source workbook and finally rename the new workbook to Rx Monthly 2019 with the same .xlsm extension.
Workbook is named Rx Monthly 2018 with .xlsm extension. Workbook has sheets for each month and an additional sheet for static information.
Thanks in advance,
Natep
