Well i am not looking for it to return data to Excel, i just want to be
able to run two sql queries one after the other in the same session.
The data from the stored procedure is going to a temp table so in a way
i am just doing a select from a table. For me to populate that table i
need to be able to run two commands together. Although the views idea
does sound equally good.

OK, so you probably don't want to go through MS Query then. Instead use ADO to connect to the
server and execute the stored proc. An example that you might be able to adapt is at:

http://www.dicks-blog.com/archives/2...do-parameters/


Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev