Solved
Report Builder Auto Refresh
Hello All,
Does latest Report builder has a capability to Auto Refresh at regular interval? Omniture ExcelClient used to have this feature but now Excel Client is no longer supported.
Please advise
Regards
Hi Sameer,
Report Builder does support auto-refresh via Excel macros. Full instructions are linked in the blog post below:
Report Builder and Macros
Earlier this year, report builder introduced support for performing simple commands such as refresh via Excel VBA macros. Now if you use macros to perform bulk tasks or basic automation, you can include report builder functions in that workflow with some simple commands. For security reasons, you cannot schedule macro-enabled workbooks for regular delivery from Adobe Analytics, but you can still save and use them locally. For the purposes of our objectives, we will leverage the “RefreshRequestsInCellsRange” along with the “Application.OnTime” function calls in VBA.
Best,
Brian