Posted to microsoft.public.excel.programming

Nick H[_3_] Nick H[_3_] is offline

external usenet poster

Posts: 48

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove Prompt to Open File as Read-Only (Excel 2007)	kerryb13	Excel Discussion (Misc queries)	3	April 19th 23 02:13 PM
Trying to read CustomDocumentProperties of an open 2007 AddIn	Nick H[_3_]	Excel Programming	1	March 24th 10 08:37 PM
Excel 2007 prompt to open file as read only	SEllis	Excel Discussion (Misc queries)	1	March 4th 10 06:29 PM
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat	Tim	Excel Discussion (Misc queries)	1	March 31st 07 11:12 AM
Addin in read-only mode problem	Stuart[_5_]	Excel Programming	1	August 20th 03 02:41 AM

All times are GMT +1. The time now is 05:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us