Access VBA to recognize Excel Creation Date

[tessinsd]

How can I get my Access 2007 VBA to recognize this Excel 2007 value[ActiveWorkbook.BuiltinDocumentProperties.Item("Creation date").Value] ? based upon the time frame between date created (as seen in the Stats tab of Excel) and Last Saved, I need to import the file.

I'm new to VBA but have been using Access and Exel for many years. Any help is appreciated!

Thanks
Tessinsd

 

[Norie]

That code works perfectly fine for me.