Change Date Created and Author

[SabCie]

Is it possible to write a VBA code that will change the Author or the Date Created of a file?

Thanks

 

[BigC]

Sure can!

Define (i.e. Name) two cells somewhere in your workbook ias "Author" and "CreationDate" respectively, to provide a place into which you can enter the Author and Date you require, then run the macro.

Sub ChangeDocumentProperties()
 
Dim MyAuthor as range
Dim MyDate as range
 
' Define (i.e. assign a name to a cell) these ranges in Excel
Set MyAuthor = Range("Author")
Set MyDate = Range("CreationDate")
 
With ThisWorkbook
.BuiltinDocumentProperties("Author") = MyAuthor.value
.BuiltinDocumentProperties("Creation date") = MyDate.value
End with
 
MsgBox "Author now recorded as: " & ThisWorkbook.BuiltinDocumentProperties("Author")
MsgBox "Creation date now recorded as: " & ThisWorkbook.BuiltinDocumentProperties("Creation date")
 
End sub