I am opening Excel workbooks use VBA in Access. I want to get the original creation date of the workbook, but what I am getting is the date is was moved to the current folder.
Dim WkBk As Excel.Workbook
Set WkBk = ExcelApp.Workbooks.Open(filename:=WbkPathName)
I tried using this, but it causes an error: