Home |
Search |
Today's Posts |
#1
|
|||
|
|||
[SOLVED] 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 Last edited by ElmerS : June 5th 10 at 11:16 AM |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Alter build-in properties
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Alter build-in properties
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 |
#4
|
|||
|
|||
Thank you, Jay,
Although it is Very "Disappointing" at least I have got an educated answer. Will use the alternative way. Elm |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Document Properties to Standard Properties Window? | Microsoft Word Help | |||
I need to edit the document properties after properties creation. | Microsoft Word Help | |||
how to alter 2.0 text into 1.5 ? | Microsoft Word Help | |||
How do I alter or remove the properties statistics (create, modif. | Microsoft Word Help | |||
Can I alter a scanned document? | Microsoft Word Help |