Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
kbutterly
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kbutterly
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kbutterly
Level 1

01-02-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

470 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

470 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

09-02-2017

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...

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
kbutterly
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kbutterly
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kbutterly
Level 1

01-02-2017

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?