View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Listing BuiltInDocumentProperties without opening workbook

I'm using this to get the custom document properties without opening a file
(and have pulled out a bunch)

dim strProperty as object
dim objDocProperties as Object

Set objDocProperties = CreateObject("DSOFile.OleDocumentProperties")

objDocProperties.Open (myFileName)

for each strProperty in objDocProperties.CustomDocumentProperties

next strProperty

is there someway I can access the builtin properties using a similar syntax.
I can't seem to get it to work.

Thanks,
Barb Reinhardt