Expand my Community achievements bar.

SOLVED

Adobe ReportBuilder automatic update

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

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.