There is no way to currently automate the refresh of queries via report builder using macros. I have tried quite a few different ways and I am unable to make it work. If someone has a solution out there please pass it along.
Macros work perfectly with the excel client.
Yes... It is really important to be able to schedule excel docs that have report builder requests and some macros... else it is just not user friendly!!