Alter build-in properties

Hi,

I saw the following thread and thought it can be adopted also for altering the Creation Date of a "Word" Document.

I tried to run the suggested commands, in the Immediate window (after replacing ActiveWorkbook with ActiveDocument).

Unfortunately, the creation date was not changed - not even with the simple "Excel like" command:

ActiveDocument.BuiltinDocumentProperties(11).Value = Date

Is there an easy way to alter that date ?

http://www.excelforum.com/excel-prog...roperties.html

Thanks, Elm

Hi Elmer,

Sorry, what works for Excel does not work for Word.

The help topic on the BuiltInDocumentProperties collection for Excel
VBA says that its members are read-only, but that isn't true. You can
write to at least some of those properties and actually change their
values; "Creation Date" is one of those.

The BuiltInDocumentProperties items in Word really are read-only. You
won't get an error if you try to write to them, but there is no way --
not easy, not hard, NO way -- to alter them via VBA.

The one thing you can do to change the creation date is to use SaveAs
to save the document to another name; then delete the original file
and rename the new one to the old name. The creation date will be the
date of the SaveAs. If you don't want it to be the current date,
temporarily change the computer's clock.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.


On Fri, 4 Jun 2010 23:19:12 +0100, ElmerS
wrote:


Hi,

I saw the following thread and thought it can be adopted also for
altering the Creation Date of a "Word" Document.

I tried to run the suggested commands, in the Immediate window (after
replacing ActiveWorkbook with ActiveDocument).

Unfortunately, the creation date was not changed - not even with the
simple "Excel like" command:

ActiveDocument.BuiltinDocumentProperties(11).Valu e = Date

Is there an easy way to alter that date ?

http://www.excelforum.com/excel-prog...roperties.html

Thanks, Elm

Hi Elmer,

Sorry, what works for Excel does not work for Word.

The help topic on the BuiltInDocumentProperties collection for Excel
VBA says that its members are read-only, but that isn't true. You can
write to at least some of those properties and actually change their
values; "Creation Date" is one of those.

The BuiltInDocumentProperties items in Word really are read-only. You
won't get an error if you try to write to them, but there is no way --
not easy, not hard, NO way -- to alter them via VBA.

The one thing you can do to change the creation date is to use SaveAs
to save the document to another name; then delete the original file
and rename the new one to the old name. The creation date will be the
date of the SaveAs. If you don't want it to be the current date,
temporarily change the computer's clock.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.


On Fri, 4 Jun 2010 23:19:12 +0100, ElmerS
wrote:


Hi,

I saw the following thread and thought it can be adopted also for
altering the Creation Date of a "Word" Document.

I tried to run the suggested commands, in the Immediate window (after
replacing ActiveWorkbook with ActiveDocument).

Unfortunately, the creation date was not changed - not even with the
simple "Excel like" command:

ActiveDocument.BuiltinDocumentProperties(11).Valu e = Date

Is there an easy way to alter that date ?

http://www.excelforum.com/excel-prog...roperties.html

Thanks, Elm

Thank you, Jay,

Although it is Very "Disappointing" at least I have got an educated answer.

Will use the alternative way.

Elm