· 

Enable Analysis for Office Addin

Before you can use Analysis for Office with Visual Basic for Application, you have to load the Analysis Addin. The code for this is in Analysis for Office 1.4:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
Private Sub EnableAnalysisOffice()
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

End Sub

 

In Analysis for Office 2.0, SAP has changed the name of the addin. The command is now:

 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
Private Sub EnableAnalysisOffice()
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

 

Now you can continue working with the SAP Analysis commands.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains 272 Pages.
27,00 €

Write a comment

Comments: 0