Access 'Company' Property for Office Document 1

[idbr]

Hi,

I'm trying to Access the 'Company' property for a list of Office documents, the one that comes up when you open the properties dialog for the file.

I'm doing this in a VBA procedure, does anyone know how to get it?

Thanks, Iain

 

[idbr]

Apologies, forgot to mention that the list is a mixture of .xls & .doc

 

[TonyJollans]

Hi Iain,

This should get it for you:

[i]Document_or_Workbook_Ref[/i].BuiltinDocumentProperties("Company")

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[idbr]

Thanks Tony, just the job.

Thanks, Iain

 

[idbr]

One other thing - I can't make this work for an Access db (apologies, not in my original scope) - any advice?

Thanks again, Iain

 

[TonyJollans]

Hi Iain,

This isn't one you stumble across by accident!

CurrentDb.Containers!Databases.Documents!SummaryInfo.Properties("Company")

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[idbr]

Wow, you're not kidding!

Thanks again, Iain