How do I show file creation date in a cell in Excel?
This line of code in an appropriate macro will do it............
Range("b1") = ActiveWorkbook.BuiltinDocumentProperties("Creation Date")
Vaya con Dios,
Chuck, CABGx3
"Eddie Armstrong" wrote:
I need to have a field on a worksheet to show the file creation date. It
can't be in the header or footer as I need to make calculations based on it.
Any clues?
Regards,
Eddie
|