I have managed to (via a sharepoint query) pull data from a list in to excel. The issue I have is that I have the below window pop up for all 6 list I am exporting. I currently have to select "Exsisting workbook" and then press "OK" everytime. Is it possible to add anything to the below code so that it will select this automatically??

Thanks in advance 

Sheets("Gen Kno Raw Data").Select
Range("A1").Select

Workbooks.Open ("??????????\Sharepoint Queries\General Knowledge Quiz.iqy")
ActiveSheet.ListObjects("Table_General_Knowledge_Quiz").Unlist
Table Pop Up.png