Hi guys,
Please could you help me on the below.
i have multiple workbooks stored in the same location. From a master workbook i want to move them all to another location renaming them by adding the current week number to the end.
Then replace them with new workbooks called the same as the previous names, which will be all in one location.
example
file location /c1 file location archive File location - New workbook
workbook1 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) Workbook1 wk33 workbook1 - copy into file location /c1
workbook2 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) Workbook2 wk33 workbook2 - copy into file location /c1
workbook3 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) workbook3 wk33 workbook3 - copy into file location /c1
This process will be repeted each week renaming them with the current week and replacing them with the blank workbooks.
Thanks in advance guys.
Please could you help me on the below.
i have multiple workbooks stored in the same location. From a master workbook i want to move them all to another location renaming them by adding the current week number to the end.
Then replace them with new workbooks called the same as the previous names, which will be all in one location.
example
file location /c1 file location archive File location - New workbook
workbook1 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) Workbook1 wk33 workbook1 - copy into file location /c1
workbook2 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) Workbook2 wk33 workbook2 - copy into file location /c1
workbook3 - move this (cut) to archive folder adding WK30 (Workbook1 wk33) workbook3 wk33 workbook3 - copy into file location /c1
This process will be repeted each week renaming them with the current week and replacing them with the blank workbooks.
Thanks in advance guys.
