2 Replies Latest reply: Oct 2, 2013 8:42 AM by N000S RSS

    Hyperion SmartView VB Macro Issue

    N000S


      I am trying to use smart view "HypMenuVSubmitData" function to submit the data in Webform through Macro. I am using the below Macro

       

      Private Declare Function HypMenuVSubmitData Lib "HsAddin"() As Long

      Sub MSubmit()

      X=HypMenuVSubmitData()

      End Sub

       

      I have two sheets

       

      Sheet2: Webform and the Above macro

      Sheet1: Form Button

       

      I have assined the Macro to button.

       

      When I run the Macro from VB editor i.e Pressing the run button, it is submitting the data

       

      But When I am clicking on the button, It is not submitting the data in the webform. I have tested giving some MsgBox just to chcek if the Macro is running or not. Like

       

      Private Declare Function HypMenuVSubmitData Lib "HsAddin"() As Long

      Sub MSubmit()

      X=HypMenuVSubmitData()

      MsgBox "Welcome"

      End Sub

       

      The message getting poped up. But HypMenuVSubmitData is not getting executed.

       

      Please help.

       

      Thanks,