Skip to Content

Analysis for Excel Add-in to run automatically when document opens

Hi Experts,


I have an issue with the Analysis add-in.

I am aware of the registry setting that enables the loading of the add-in at Excel startup (which works great by the way), but this is not desired.

My issue is that whenever a user opens up an analysis for Excel document ,and the add-in is not loaded, the document cannot be refreshed. The user then has to activate the add-in and refresh.

Is there a way to embed a code in the Excel document to load the add-in every time it opens (if the add-in is not loaded)? A button in the excel to activate the add-in would also work great.

I tried this VBA code, but no luck. I guess it has something to do with the add-in being a COM add-in.

Private Sub Workbook_Open()

AddIns("Analysis").Installed = True

End Sub

Thanks,

Ofer

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 09:30 AM

    Hi,

    Are you looking for something that will do this.

    Dim lResult As Long
    Dim addin As COMAddIn

    For Each addin In Application.COMAddIns

    If addin.progID = "SBOP.AdvancedAnalysis.Addin.1" Then

    If addin.Connect = False Then addin.Connect = True

    End If

    Next

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2013 at 03:27 PM

    If you are using the latest AO and BIP combination, you can save your workbooks using a new, AO specific InfoObject type. This will start Excel with the AO plugin. You can then leave your startup state registry setting set not to start Analysis every time Excel starts.

    Cheers,

    Dave

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 06, 2019 at 10:19 AM

    Hi,

    I'm not sure if this is related to an Analysis for Office update or just a parameter that is different but in my case the addin progID is "SapExcelAddIn" and not "SBOP.AdvancedAnalysis.Addin.1" which gives the following code:

    Private Sub Workbook_Open()

    Dim lResult As Long

    Dim addin As COMAddIn

    For Each addin In Application.COMAddIns

    If addin.progID = "SapExcelAddIn"

    Then If addin.Connect = False Then addin.Connect = True

    End If

    Next

    End Sub

    Regards,

    Sébastien

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.