Excel VBA and SQL stored procedure with multiple data sets

[dfuas]

Hi All

I have an established SP that generates multiple data sets. I can get at the first dataset but not all the others.

Does anyone knows if it is possible and how to get all the other data sets.

I am using Excel 2007 VBA and some of the code is as follows:

Also how can I save the query so that I can refresh this when needed. I used to be able to do it on Excel 2000 & 2003 but 2007 seems quite a different beast.

Thanks

df

 'refresh queries on each tab
    With TemplateBook.Sheets("Quality Review").Range("A8").QueryTable
       .CommandText = "EXEC s_ProcTable @TableName = '" & strTables & "'"
       .Refresh BackgroundQuery:=False
    End With