Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltinDocumentProperties
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? | Excel Discussion (Misc queries) |