Accessing builtin properties without opening workbook

M

midori

Hi,

I want to be able to access a workbook's builtin properties from
another workbook. It seems that I can only if the workbook is open. Is
there a way of reading the values of a workbook's
BuiltinDocumentProperties without opening the workbook in question?

Thanks,
Shu
 
P

papou

Hello Shu
Yes you can read document properties without opening them.
Use DSOFILE.DLL which you should find for download.

HTH
Cordially
Pascal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

correlating and summing data from multiple spreadsheets 1
Excel 2003 looses document properties 4
Linking to Access data without destroying formulas 16
WorkBook Custom Properties 1
Macro-copy 6
Pass Workbook Name Into Another Workbook As A Variable 4
Force users to enable macros on a protected workbook? 6
Macro for EACH workbook-->help modify to ONE macro for ALL workbooks? 23

Top