Excel 97, get with VBA the date of creation of a workbook
Posted by Pierre on December 06, 2001 12:24 AM
I am looking for a way to get in a Macro (Excel 97) the date of creation of a workbook. That date can be found manually clicking on 'Properties* of the workbook.
I am expecting sth as follows:
myDate = ActiveWorkbook.Date.Created
or myDate = ActiveWorkbook.Properties.CreationDate
but I just haven't been able to find my way through in the VBA help files.