Workbook Properties

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marvin Buzz - 23 May 2008 15:44 GMT

Is it possible to access any of the workbook properties using VBA?

Reply to this Message

Rick Rothstein (MVP - VB) - 23 May 2008 16:09 GMT

> Is it possible to access any of the workbook properties using VBA?

Which properties did you have in mind?

Rick

Reply to this Message

Norman Jones - 23 May 2008 16:28 GMT

Hi Marvin,

See Chip Pearson at:

Getting A Built-In Or Custom Document Property
http://www.cpearson.com/excel/excelM.htm#Properties

---
Regards.
Norman

> Is it possible to access any of the workbook properties using VBA?

Reply to this Message

Chip Pearson - 23 May 2008 16:29 GMT

Marvin,

Yes, it is certainly possible. See
http://www.cpearson.com/Excel/DocProp.aspx for example code.

Signature

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

> Is it possible to access any of the workbook properties using VBA?

Reply to this Message