How to change the creation date in excel

[arun198322654]

 

[NARAYANK991]

Hi ,

The Content Created date can be changed by :

ActiveWorkbook.BuiltinDocumentProperties.Item(11).Value

but the Last Saved Date is changed by the system as and when the file is saved , and hence if your code changes it , that change will be overwritten by the system when the file is saved.

See this link for how to do this using a file called DSOFile.dll :

https://www.excelforum.com/excel-formulas-and-functions/555006-list-file-properties-author.html

Narayan

 

[bobhc]

Are you trying to alter properties to claim someone else work as your own????

 

[SirJB7]

Hi, b(ut)ob(ut)hc!
I'd actually try to claim your work as mine, my friend... but there's a little problem: you should work first... and neither Ninjas nor Chandoo succeeded at such tremendous task.
Best regards!

 

[bobhc]

@SirJB7
Hello, my friend good to see you are a live and kicking, work is something I no longer have to do, my time is mine to do as I wish. I hope life is treating you well.

 

[SirJB7]

Hi, b(ut)ob(ut)hc!
My dear friend, so long... nice to read you again. Yes, I know you're retired, but I never had a proof that you had ever worked. Fortunately life is treating me well, I'd say very well except sometimes for my woman, usually for my son, for all the other women (except for the Ninjas at Chandoo), for a few relatives, for many so called friends, for enough enemies, for those guys of the tax office... and the list follows. But (and I once read that there's always a but...t) otherwise it'd be very boring, wouldn't it?
My best regards for my oldest friend ever!