Possible to access workbook properties in VBA?

[JasonC71]

Hi,

I have a need to for some code to check what workbook the code is being run on....in other words...I need it to say "if the ActiveWorkbook is X then do the following, else, do this." The thing is, I can't use workbook X's Name, as it changes quite frequently....so i'm looking for another way to check and see if workbook x is the active workbook. Under workbook properties, you have things like Author, Subject, etc. Can I call these properties from within a macro to check and see if the workbook in question is my special "X" workbook? (The name of the workbook may change, but the subject line in properties will not and is unique.)

Thanks,
Jason

 

[RoryA]

You can use:

ActiveWorkbook.BuiltinDocumentProperties("Subject")

HTH

 

[JasonC71]

Thanks!!

I'll give that a try tonight...I tried to capture that with the macro recorder, but got nothing....thanks for the info.

Jason

 

[RoryA]

In case it's of interest, you can also add your own custom document properties to workbooks and check for those.

 

[JasonC71]

Really....could you point me in the right direction on how to do that?

Thanks,
Jason

 

[RoryA]

Via the Custom tab in the Properties dialog. You can then check them using the ActiveWorkbook.CustomDocumentProperties collection in code, similar to the above. Let me know if you need more detail.