Read date file created without VBA?

[Cferron]

Is it possible to output the creation date of a closed file in a specific cell without using VBA. I'm on Excel365 and VBA is not possible to be activated.

Thanks

Claude

 

[JEC]

Nope you need VBA

Function jec() As Date
 sq = "C:\Users\xxx\xxx\xxxx.xlsm"
 jec = CreateObject("scripting.filesystemobject").getfile(sq).datecreated
End Function

 

[Cferron]

Ok, to enable VBA in excel365 I guess the administrator has to do this...

 

[eastrand]

Depending what your scenario is. As @JEC said, you need VBA to get file properties from within an excel file. You can use PowerAutomate to retrieve this information and then write it into a cell within the excel file.