I am using a macro in Excel VBA which opens a text file as a workbook.

I need to get the Creation Date of the text file, not the Last Modified date.

So far I cannot find any way to get the creation date using the Workbooks object in VBA, and FileDateTime sometimes gives the Last Modified date.