ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Workbook Properties (https://www.excelbanter.com/excel-programming/411449-workbook-properties.html)

Marvin Buzz

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

Rick Rothstein \(MVP - VB\)[_1985_]

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

Which properties did you have in mind?

Rick

Norman Jones[_2_]

Workbook Properties
 

Hi Marvin,

See Chip Pearson at:

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


---
Regards.
Norman


"Marvin Buzz" wrote in message
...
Is it possible to access any of the workbook properties using VBA?



Chip Pearson

Workbook Properties
 
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)



"Marvin Buzz" wrote in message
...
Is it possible to access any of the workbook properties using VBA?




All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com