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.