Trying to call excel Com-Addins directly rather than Keynote

[divyaglenny]

 

I tried various methods to call the addins directly, We were able to use keynotes but we need a direct connection to the dodeca for auto refresh of the files.
 

#include <Excel.au3>
;Function to log errors to a File
Func LogError($errorMsg)
   FileWriteLine(@ScriptDir & "\error_log.txt", @Hour & ":" & @MIN & ":" & @sec & "-" &$errorMsg)
   MsgBox(16,"Error",$errorMsg)
EndFunc

;Function to connect to essbase and refresh specific cells

Func RefreshEssbaseData($excelFilePath,$serverName,$applicationName,$databaseName,$userName,$sheetNames)

   ;open excel application
   Local $oExcel=ObjCreate("Excel.Application")
   if not IsObj($oExcel) Then
      LogError("Unable to open Excel.")
      Exit
   EndIf
   $oExcel.Visible=True ;Making excel visible for debugging

   ;open the workbook
   Local $oWorkbook=$oExcel.Workbooks.open($excelFilePath)
   ConsoleWrite("Workbook opened successfully:" & $excelFilePath & @CRLF)
   If not IsObj($oWorkbook) Then
      LogError("Unable to open workbook" & $excelFilePath )
      $oExcel.Quit()
      Exit
   EndIf

local $bDodecainstalledInstalled=False
for $i=1 to $oExcel.CommAddIns.Count
   if StringInStr($oExcel.CommAddIns.Item($i).Name,"ApplieadOLAP.Dodeca.ExcelAddInForEssbase") then
      $bDodecainstalledInstalled=True
      Exit
   EndIf
   ConsoleWrite($bDodecainstalledInstalled & @CRLF)
Next

 

Edited June 24, 2024 by Jos
added codebox

[water]

This might be a good starting point: https://learn.microsoft.com/en-us/office/vba/api/excel.addin

[divyaglenny]

in this case we will have to create a vba macro and call it right? I'm looking in to connect directly through auto it.

 

[water]

I do not think you need to create a VBA macro.
In this (quite old) thread it seemed to work without VBA: