Loading addins when Excel is instantiated programmatically

by

I looked into this problem again, and the Application.Addins collection seems to have all the addins listed in the Tools->Addins menu, with a boolean value stating whether or not an addin is installed. So what seems to work for me now is to loop through all addins and if .Installed = true then I set .Installed to False and back to True, and that seems to properly load my addins.

Function ReloadXLAddins(TheXLApp As Excel.Application) As Boolean

    Dim CurrAddin As Excel.AddIn

    For Each CurrAddin In TheXLApp.AddIns
        If CurrAddin.Installed Then
            CurrAddin.Installed = False
            CurrAddin.Installed = True
        End If
    Next CurrAddin

End Function

More Related Contents:

  1. we want to search for an empty column and add items to that column using a vba form
  2. Error in finding last used cell in Excel with VBA
  3. Excel VBA, getting range from an inactive sheet
  4. How to use the Implements in Excel VBA
  5. What is the difference between dim and set in vba
  6. How to set recurring schedule for xlsm file using Windows Task Scheduler
  7. Populate unique values into a VBA array from Excel
  8. Excel VBA App stops spontaneously with message “Code execution has been halted”
  9. Closing Excel Application using VBA
  10. How to clear memory to prevent “out of memory error” in excel vba?
  11. Delete Row based on Search Key VBA
  12. How to add a button programmatically in VBA next to some sheet cell data?
  13. What are the benefits of setting objects to “Nothing”
  14. How can I kill task manager processes through VBA code?
  15. VBA: Usage of parentheses for a method
  16. Fully reference a worksheet by codename
  17. OnTime for less than 1 second without becoming Unresponsive
  18. Get Unicode characters with charcode values greater hex `FFFF`
  19. How do I click a link on a web page using Excel VBA?
  20. Ping IP Address with VBA code and return results in Excel
  21. VBA copy cells value and format
  22. Multiply Entire Range By Value?
  23. VBA Excel – IFERROR & VLOOKUP error
  24. Finding a workbook in one of multiple Excel instances
  25. Delay macro to allow events to finish
  26. declaring a unicode string in vba in excel [duplicate]
  27. How to programmatically code an ‘undo’ function in Excel-Vba? [duplicate]
  28. Change the Point Color in chart excel VBA
  29. Extract URL From Excel Hyperlink Formula
  30. Change HTML email body font type and size in VBA

Leave a Comment