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

Adobe ReportBuilder automatic update

Avatar

Avatar
Validate 1
Level 1
rodrigom2545686
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rodrigom2545686
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

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

26-11-2018

Good morning,

I need to update an Adobe Report through VBA on Excel, but the Visual Basic Macros provided by you on the Adobe website (https://helpx.adobe.com/analytics/kb/visual-basic-macros-reportbuilder.html) are taking around 10 times longer than when we update the report manually (~40 minutes compared with 4 minutes).

Is that the expected performance within these macros?

Is there a way to automatically update the ReportBuilder faster?

Since it's not a native Excel process, I can't even record the macro, so all I can do is use the ones provided here.

Thanks for your time.

Rodrigo

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

18-12-2018

There's no expected performance with those macros, since that would heavily depend on the end user's machine.

You can schedule Report Builder workbooks at regular intervals, which would send a new updated workbook to your inbox. That seems to be the easiest way to not need to worry about refreshes.

Answers (1)

Answers (1)

Avatar

Avatar
Establish
Level 2
kglad
Level 2

Likes

12 likes

Total Posts

45 posts

Correct Reply

2 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Establish
Level 2
kglad
Level 2

Likes

12 likes

Total Posts

45 posts

Correct Reply

2 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
kglad
Level 2

26-11-2018