ExcelBanter - Can I change a file's properties in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I change a file's properties in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/252785-can-i-change-files-properties-excel.html)

Ron100

Can I change a file's properties in Excel?

I copy an excel file each year and update the dates etc to enter a new year's
set of figures. The File Properties still show the original date that the
file was created. How can I amend the creation date to show the current year?

Bob I

Can I change a file's properties in Excel?

What about Select and Copy the Worksheet to a New Book instead?

Ron100 wrote:

I copy an excel file each year and update the dates etc to enter a new year's
set of figures. The File Properties still show the original date that the
file was created. How can I amend the creation date to show the current year?

All times are GMT +1. The time now is 06:41 PM.