Excel query then insert row
 

Please help - what sort of VBA code would I need to first run an Excel query
against workbook 1, then add the results from the same query against workbook
2? I do not know where the INSERT INTO goes, or if I need to change the
activewindow so that workbook 2 is referenced after the first query is ran.