Dim fso As New FileSystemObject
Dim fi As File
Dim DT As Date
Set fi = fso.GetFile(ActiveWorkbook.Path & "/" & ActiveWorkbook.Name) 'percoso e nome file
'MsgBox Day(fi.DateCreated) & "/" & Month(fi.DateCreated) & "/" & Year(fi.DateCreated)
'MsgBox fi.DateLastAccessed
'MsgBox fi.DateLastModified
DT = Day(fi.DateCreated) & "/" & Month(fi.DateCreated) & "/" & Year(fi.DateCreated)
perfetto funziona benissimo, grazie
l'ho adattata cosi in quanto solo il comando dava sia data che ora
excel 2010