ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trying to read CustomDocumentProperties of an open 2007 AddIn (https://www.excelbanter.com/excel-programming/441026-re-trying-read-customdocumentproperties-open-2007-addin.html)

Nick H[_3_]

Trying to read CustomDocumentProperties of an open 2007 AddIn
 
Hmmm...

Nice idea Gary but AddIns don't have an 'Active' property. i.e. the
following won't work...

For Each AdIn In Application.AddIns
If AdIn.Name = gsENGINE_NAME Then
AdIn.Activate
Call CheckForUpdates(ActiveWorkbook)
End If
Next AdIn

....the AdIn.Activate line triggers Error 438 - Object doesn't support
this property or method.

Any other takers?


All times are GMT +1. The time now is 11:52 PM.

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