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
Printable View
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
I haven't use it much, but it appears the category information is stored in BuiltinDocumentProperties.
VB Code:
For Each p In ActiveWorkbook.BuiltinDocumentProperties Debug.Print p.Name & ": "; p.Value Next
Thanks WhiteWay, I knew there must be a way but couldn't find it anywhere, thanks again.