Macros not compatible with Report Builder

[#1]

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.

[#2]

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!!

[#3]

We have included support for macros in report builder with a recent release, and the topic was covered in depth on this other thread: http://ideas.omniture.com/t5/Idea-Exchange-for-Adobe/Reportbuilder-Add-VBA-support-to-trig ger-data-refresh-from-a/idi-p/6537