There's a bug in PAX in that None of the action button requests to Auto Recalc or Rebuild does anything to Quick Reports.
I have this piece of code that works by intercepting the call to PAX's action button handler and putting in a call to the API at the end.
The enableevents code is essential to getting this to work. However I have a problem with the action button code in that it does not seems to return a different value according to whether you did not confirm to execute it, executed it successfully or executed it with an error. In all 3 cases msgbox x returns "OK".
In my example I ask if the user has committed his changes and if not the worksheet_refresh happens regardless and so his changes get lost.
' MsgBox Err.Number
' MsgBox Err.Description
Public Sub ExecuteAction_ebbe0d00_303c_49ee_a406_a1a72e837acf()
On Error Resume Next
Application.EnableEvents = False ' => disable events
x = Application.Run("ExecuteActionButton", "ebbe0d00_303c_49ee_a406_a1a72e837acf")
Application.EnableEvents = True ' => enable events
Does anyone have any idea how to fix this or is on a higher version of PAX/PAW than me where this is fixed? (I'm on PAX 2.0.57)
Thanks in advance.
LICENSE_CAFE_COR_name=IBM Cognos License
SWTAG_CAFE_COR_name=SWTAG Analysis for Excel
[Product Update Information]
COR_APP_name=Cognos 8 Analysis for Excel
CAFES_name=Cafes for Excel
CORREDIST_name=IBM Planning Analytics for Excel
COI_name=IBM Cognos COI
1 post • Page 1 of 1