Can I change a file's properties in Excel?

[Ron100]

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]

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

 

[מיכ×ל (מיקי) ×בידן]

On the new created file try to run the following macro:

 

[Ron100]

Many thanks Micky - that worked a treat - Ron

On the new created file try to run the following macro:

 

[Ron100]

Many thanks Micky - the macro worked and date was changed

Ron