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:
____________________________________________________________________________________________
____________________________________________________________________________________________
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:
____________________________________________________________________________________________
____________________________________________________
Bookmarks