Reading Built-in Properties of Closed Workbooks

[Arthur494]

I have a folder containing about 25 workbooks. I want to open some of them by rotation in my Excel VBA code. I could identify those that I want to open by searching for a substring within the filename. BUT I would prefer to use another built-in property of the workbooks, e.g. Tags, Keywords, Category etc. Is it possible to read one of these properties from a closed workbook, please?
tia

 

[GlennUK]

Look at this page, and look for the section headed Returning Property Values From A Closed File:

http://www.cpearson.com/excel/docprop.aspx

 

[Arthur494]

thanks!