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 

Please Login or Register  to view this content.
Table Pop Up.png