Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation?

  • Thread starter Thread starter EagleOne
  • Start date Start date
E

EagleOne

2003

What syntax is proper to address the following VBA after Late Binding via Access?:

ThisWorkbook.BuiltinDocumentProperties("Creation Date") = myDate & " " & myTime

The code fails even though I used:

Dim ThisWorkbook as Object (in the Access VBA module to accomodate late binding of Excel libraries)

TIA EagleOne
 
According to the Help file for Excel 2003, the built-in document properties
are read-only.
 
Well Doug,

I guess that is why!! I thought that there was a VBA way to change the properties.
Live and learn. Thanks!

EagleOne
 
Back
Top