BuiltinDocumentProperties

[booshi]

I want to selectively copy data from a group of workbooks to a master
workbook. But open workbooks takes time.

Could I get the BuiltinDocumentProperties of the workbook without opening
them?

Thanks

 

[Frank Kabel]

Hi
AFAIK the workbook has to be opened for this

 

[Michel Pierron]

Hi booshi;
You can do it with DSO
http://download.microsoft.com/download/office97dev/Utility/2/WIN98/EN-US/Dsofile.exe
MP

 

[Chip Pearson]

See the "Document Properties Of Closed Files" section at
http://www.cpearson.com/excel/docprop.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com