Excel Category property

[c.p.morris]

Can anyone tell me how to return the Properties of an Excel spreadsheet, I need to get the 'Category' (from Excel menu - File, Properties, Summary).

Thanks

[whiteWay]

I haven't use it much, but it appears the category information is stored in BuiltinDocumentProperties.

For Each p In ActiveWorkbook.BuiltinDocumentProperties
    Debug.Print p.Name & ": "; p.Value
 Next

[c.p.morris]

Thanks WhiteWay, I knew there must be a way but couldn't find it anywhere, thanks again.