Joop,

Is that because the activeworkbook is not an Excel worksheet? ACtiveworkbook
works okay for an Excel workbook.

--

HTH

Bob Phillips

"Joop" wrote in message
...
I'm what one would call a newby and was trying to get the
Creation Date of a .html file I open in Excel.
The code below works, but it gives me the creation date of
the Excel file where the code resides.
Changing to ActiveWorkbook gives an error.

Windows("SC1A.html").Activate
Cells(6, 7).Value = ThisWorkbook.BuiltinDocumentProperties
("Creation date").Value

Has anyone an idea how to solve this?

Joop van de Sande