BuiltinDocumentProperties

[Joop]

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

 

[Bob Phillips]

Joop,

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

 

[Joop]

I tried following code which does return the
BuiltinDocumentProperties names.
Changing the code to show the values gives that runtime
error again.
What is wrong with this code?

Dim p, col As Integer

Windows("SC1A.html").Activate
col = 1

For Each p In ActiveWorkbook.BuiltinDocumentProperties
Cells(6, col).Value = p.Name
col = col + 1
Next