Can I change a file's properties in Excel?

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

On the new created file try to run the following macro:
-------------------------------------
Sub Change_Create_Date()
ActiveWorkbook.BuiltinDocumentProperties(11).Value = Date
End Sub
----------
Micky

"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?

's Computer Specifications

Many thanks Micky - that worked a treat - Ron

"מיכאל (מיקי) אבידן" wrote:

> On the new created file try to run the following macro:
> -------------------------------------
> Sub Change_Create_Date()
> ActiveWorkbook.BuiltinDocumentProperties(11).Value = Date
> End Sub
> ----------
> Micky
>
>
> "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?

's Computer Specifications

Many thanks Micky - the macro worked and date was changed

Ron
"מיכאל (מיקי) אבידן" wrote:

> On the new created file try to run the following macro:
> -------------------------------------
> Sub Change_Create_Date()
> ActiveWorkbook.BuiltinDocumentProperties(11).Value = Date
> End Sub
> ----------
> Micky
>
>
> "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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to change file properties	TomH	Microsoft Excel Programming	1	2nd Jul 2008 04:52 PM
How do I change file properties?	=?Utf-8?B?TWFydGluZWxsaXM=?=	Windows XP Security	5	25th Dec 2005 07:40 AM
Properties transferring from excel cells to word file properties	=?Utf-8?B?bHVibw==?=	Microsoft Excel Programming	4	12th Jul 2005 11:24 AM
Change file properties	Sketcher	Windows XP Photos	0	24th Aug 2004 04:40 PM
can't change file and folder properties	stan	Windows XP Performance	1	26th Dec 2003 11:23 PM