Re: My .xla custom menu items doesn't show up when using 3rd party software

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you create the code you can use this for example to open Excel with add-ins
from another program.

But you use a 3rd party application.


This was suggested by KeepItCool and should work:

Code from KeepItCool (Oct 21, 2004)

Sub LoadXLwithAddins()
Dim xl As Object
Dim ai As Object

Set xl = CreateObject("Excel.Application")

For Each ai In Application.AddIns
If ai.Installed Then
xl.Workbooks.Open(ai.FullName).RunAutoMacros 1
End If
Next

xl.Visible = True
Set xl = Nothing
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael Malinsky" <mmalinsky@xxxxxxxxx> wrote in message news:1160518928.741819.308310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
@smw226: I'll give that a try...thanks.

@Ron: Any workaround suggestions other than what was already
suggested?

Thanks.

On Oct 10, 4:45 pm, "Ron de Bruin" <rondebr...@xxxxxxxxxxxx> wrote:
hi Michael

If you run Excel from another program code in Add-ins will not run
(you see the add-ins checked in Tools>Add-ins)

Run this in Start > Run in Windows with Excel closed and you see it

excel.exe /s

--
Regards Ron de Bruinhttp://www.rondebruin.nl

"Michael Malinsky" <mmalin...@xxxxxxxxx> wrote in messagenews:1160511426.655329.88050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Long subject line...sorry.

Anyway, I have created an .xla add-in that creates a custom menu item
on the standard menu bar. This works fine when opening Excel.

However, we use a 3rd party application that integrates with Excel
(essentially document management software) that is causing problems.
If I open a workbook through that software, the menu that is supposed
to be created with my add-in does not appear even though the add-in is
checked in the Tools>Add-ins dialog. If a uncheck and add-in, close
the Add-in dialog, open the Add-in dialog, check my add-in, then close
the Add-in dialog, the menu appears like it should.

I would like to distribute this add-in to everyone at my office, but
this is a sticking point for which I cannot seem to find a solution.

Thanks,
Mike.



.

Relevant Pages

  • Re: Shared Add-ins just dont work
    ... Since posting I have succeeded in getting an automation add-in to ... the Excel instance. ... OnStartupComplete(ref custom); ... IDTExtensibility2 interface. ...
    (microsoft.public.office.developer.automation)
  • Re: CLEAN function - macro??
    ... In excel 2007 I can add that add-in to the most used commands or quick ... want to clean, and then click a toolbar item to do the clean. ... learn the count of selected cells in the worksheet, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Com- Addin für Excel
    ... <<nur die Vorteile von "besserer Kopierschutz möglich, ... COM Objekten ist immer mit Änderungen der registry ... wenn ich den com add-in ausführen will, ... normalerweise alle das gleiche EXCEL per Order von oben. ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: .net Com Add-in IDTExtensibility type library could not be loaded
    ... > I have been developing an Excel Add-in and had made many successful ... Shared Addin project, I noticed that the IDTExtensibility2 Interface ...
    (microsoft.public.office.developer.com.add_ins)
  • RE: Weird AddIn behaviour
    ... key if the add-in is of the same name. ... The code must reside outside of Excel ... / VBA because anything you do to the registry will be overwritten when you ... opens the file from the original path. ...
    (microsoft.public.excel.programming)