LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Cannot find a loaded VBA addin

Hi,

I have an addin, lets call it 'office2003addin.xla' which is loaded into
Excel on startup because it is in the %App data%\Microsoft\Excel\XLSTART
directory. The issue I have is that it conflicts with an office 2007 COM
addin that I have created which needs to call VBA procedures in another
addin, lets call it 'office2007addin.xlam'.

I am running VSTO code which calls the VBA. The aim is that before I call
any VBA code I first check that office2007addin.xlam is loaded, and if not
then I load it using Application.addins.

I also want to check that office2003addin.xla is not loaded, and if it is to
remove it. The problem is that office2003addin.xla is not listed as an
active Addin, is not included in the Application.Addins or
Application.Workbooks collections so I have no way of removing it, but yet if
I go to the VBA editor I can see it listed as a project, and it is loaded
since I can call functions it contains.

This is a bit of a strange situation, but we have the 2003 addin deployed to
a lot of machines and I cannot guarantee that it will be removed when we
install the new version of office.

Has anyone seen this before, and is there any way of removing the addin, or
at least telling if it is there (short of removing the file from the PC,
which I cannot do).
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Stuck addin loaded helmekki[_102_] Excel Programming 0 November 15th 05 12:29 AM
Display sheet from loaded Addin Stuart[_21_] Excel Programming 3 March 10th 05 06:59 PM
Addin opened but not loaded Jac Tremblay[_3_] Excel Programming 1 November 30th 04 04:15 PM
XLL addin not loaded! Tetsuya Oguma[_4_] Excel Programming 6 October 22nd 04 02:54 PM
Addin loaded but Macro not shown Blair C. Fonville Excel Programming 2 September 8th 04 04:26 PM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"