At this time it is not possible to automate running a macro via the RE Queue service.  Consider developing an executable built with The Raiser's Edge API that is called by a SQL Job or Windows Scheduling service as the RE Queue service is not able to cause a macro to execute.

For more information, please see:
What is RE:Queue?
What are VBA macros?