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
Solved! Go to Solution.
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies