I had to go back and use 2007, working in 2010 for sometime now I can not find in the macro builder the action to run a query. I want to set up a macro to run Query 1, then Query 2, and export the data to excel. However I am held up due to my in ability to find the run function for the query in the macro builder ;(

WOW, did I make a Need a V8 commerical. OpenQuery = RUN IT : (