Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error querying for open VBprojects in XP?
An add-in of mine checks to see whether an add-in is
installed OR loaded, since it will work in both cases. To see whether the add-in is loaded, I use Dim AddInLoaded As Boolean Dim p As Object AddInLoaded = False For Each p In Application.VBE.VBProjects AddInLoaded = AddInLoaded Or (p.Name = "MyAddInName") Next p This worked fine with Excel97 and Excel2000, but I get a run-time error 1004 in the latest Excel versions: something to do with accessing projects from within a project. Is there a way to get around this that will work with the older XL-versions as well? TIA, Arne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Querying Worksheets | Excel Worksheet Functions | |||
EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
Error in querying data from MS Access | Excel Discussion (Misc queries) | |||
Querying data | Excel Discussion (Misc queries) | |||
Web Querying from excel. | Excel Programming |