Autoselect where to put the data when importing an IQY file

Hi forum,

I have got a nasty problem which I cannot get resolved.

I have created an excel file that connects to a set of 6 SharePoint lists using webqueries (IQY files). The option I use is a read connection, so any change in SharePoint can be refreshed in excel. A connection is astablished by doubleclicking the file which than dynamicly links the SharePoint list to Excel. So far so good.

I have added 6 connections to the excel file and seem to run into cappacity issues. Whenever I (re)open the file it forgets the links.

So I created a vba script to import the files automaticly for me:

____________________________________________________________________________________________

Please Login or Register  to view this content.

____________________________________________________________________________________________

Whenever I run this script it pops up this screen which I would like to autopopulate:
27-08-2014 11-06-32.png

I would like the script to automaticly select the [New worksheet] option, but i cannot find where to set this parameter.

I searched the internet for clues but cannot find anything that works.

Your advise is most appreciated.

Regards,
Michiel





Here is an example of the IQY file contents for reference:

____________________________________________________________________________________________

Please Login or Register  to view this content.

____________________________________________________