2 Replies Latest reply on Dec 24, 2013 8:40 PM by Celvin Kattookaran

    Hyperion Add in Excel not opening with VB Script

    user12303410

      Hello Experts ,

      Excel 2007  Hyperion 11.1.1.3.

      I have written a macro using HsAddin.dll to pull the data from Essbase cubes . It is Working fine when the Excel is open .

      If I call the excel and excecute a macro through Vb script ,the Add-in got disabled and the data pulling is not working .

      I try to add the add in manually in the VB script which is also not working for me .

      Please help .

      This is the VB script Used '

      Option Explicit

      On Error Resume Next

      ExcelMacroExample

      Sub ExcelMacroExample()

        Dim xlApp
        Dim xlBook
        Dim Myaddin

         Set xlApp = CreateObject("Excel.Application")
         xlApp.Visible = true

          Set xlBook = xlApp.Workbooks.Open("C:\users\calex\desktop\SAValidation(2).xlsm")
         Set Xlbook = XlApp.AddIns.Add("C:\Oracle\Essbase\products\Essbase\EssbaseClient\bin\HsTbar.xla")

         xlApp.Run "Mail"
        xlApp.DisplayAlerts = False
        xlApp.ActiveWorkbook.Save "C:\users\calex\desktop\SAValidation(2).xlsm"
        xlApp.ActiveWorkbook.Close
        xlApp.Quit

        Set xlBook = Nothing
        Set xlApp = Nothing

      End Sub

       

      Regards

      Alex