ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listing BuiltInDocumentProperties without opening workbook (https://www.excelbanter.com/excel-programming/426974-listing-builtindocumentproperties-without-opening-workbook.html)

Barb Reinhardt

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


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com