Page 1 of 1
Error 400 in PAx
Posted: Mon Jan 20, 2020 10:05 am
by TimeTq
Hello everyone
I get this error message every time I push button created by IBM PA.
Does anybody know how to solve this problem?
Thanks
Re: Error 400 in PAx
Posted: Mon Jan 20, 2020 6:41 pm
by gtonkin
Got any protected sheets?
Possibly hidden sheets?
Wild guesses here.
Re: Error 400 in PAx
Posted: Mon Jan 20, 2020 10:21 pm
by EvgenyT
Any VBA macros?
Re: Error 400 in PAx
Posted: Tue Jan 21, 2020 8:50 am
by TimeTq
I hadn't connect CognosOfficeTM1.xll and CognosOfficeBI.xll. After connection buttons TI Process start working.
But this error shows when i start this VBA code:
Public Sub ExecuteAction_4ded29e8_f7af_4b6e_bff8_787d58e98cd4()
'RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
Range("I10") = Reporting.GetCurrentReport(Range("E9")).RebuildSpecification
End Sub
Public Sub ExecuteAction_132bb8bd_03bb_4a3d_abb5_409d57bfd329()
Dim a As String
a = Range("I10")
' ExecuteQuery is a method used to execute selected MDX statements in your Quick Report reports.
Range("M1:AA1") = Reporting.ExecuteQuery("...", "...", a)
' RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
'Workbooks("TEST.xlsm").Sheets("List2").Range("F15") = Reporting.GetCurrentReport(ActiveCell).RebuildSpecification
End Sub