Hello!
I am trying to created a database in Access that ingests excel files and populates the access database. One of the column parameters I would like is the "Date Created" Document property saved as a "date/time" data type.
I found this Excel VBA function that works for an active workbook, but does not work for Access:
"
Public Function CreaDate() As Date
CreaDate = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
End Function
"
Anyone know how to do this?
Thanks!