Workbook Properties

[Marvin Buzz]

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

 

[Rick Rothstein \(MVP - VB\)]

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

Which properties did you have in mind?

Rick

 

[Norman Jones]

Hi Marvin,

See Chip Pearson at:

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

 

[Chip Pearson]

Marvin,

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


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