VBA Macro code to refresh query
I am running BI7.1 and have set up a workbook with various queries that have to be run on separate days.
I have a cover page that I have set up and want to have buttons on this page that when clicked will only refresh the relevant query for that specific day.
I have searched online in various places and have only found the VBA code to do this using the old BEx Analyser (3.5)
Is there a way or code available to enable me to automaticallt refresh a query using a macro?