I want to be able to automatically create a new sheet and in cell A1 of each sheet create a data web connection from a list of URL's on another sheet.

This is the code for creating a Data Web Connection.

Please Login or Register  to view this content.
I would need the spreadsheet to do the following:
Create a new sheet
Rename the sheet (based on data in a different sheet [lets call this Sheet A])
Select Cell A1
Create the Data Web Connection based on the URL in sheet A

& Repeat this process, going down the data stored in Sheet A.

I Hope this all makes sense, do let me know if anything is unclear.