Report Builder - how to capture errors when using VBA macros to refresh data

[kbutterly]

Hello all,

I have an Excel 2013 workbook that has two Report Builder requests.  Request B (a Page Path report) is dependent on Request A.  Request A references data entered by the user.  If the user enters bad data (a non-existent URL path) then Request A returns no data and Request B fails with "Pathing patter filter cannot be empty".

I am trying to give the user a more friendly error, since I know what most likely caused the error, i.e. the aforementioned bad URL string.  I have added error handling just to see what I can get, but the code is apparently ignored.

On Error GoTo ErrorHandler

....

Exit Sub
ErrorHandler:
    MsgBox ("Error number: " & Str(Err.Number) & vbNewLine & _
           "Source: " & Err.Source & vbNewLine & _
           "Description: " & Err.Description)
End Sub

Any ideas of how to capture and overwrite the built in error message?

Thanks,

Kathryn

[kbutterly]

It occurs to me that this might not be seen by Excel as an error message, which raises the question, can I capture that dialog box in some way?

[Gigazelle · Accepted solution]

Hi Kathryn, what if you used VBA to refresh the workbooks as well? Explanation on how to do that is located here: https://marketing.adobe.com/resources/help/kb/en_US/analytics/kb/visual-basic-macros-reportbuilder.h...