Automatic Web Data Query Creation

I am trying to create a macro that will automatically create: sheets and data connections, based on the URLs within one 'central' sheet - rather than manually having to navigate and enter the URL for each sheet. This is what I have so far...

Please Login or Register  to view this content.

("data!A1")( - Sheet called "data", Cell A1 has an un-hyperlinked url (just text)

Once I can get this working I will also need to make it so that it scrolls through column A in the 'data' sheet to create a sheet/connection for each cell with a URL in.

Any/all advice/help is welcome!

Use Sheets("data").Range("A1").Value to reference the value.

Here's one way to loop through column A:

Please Login or Register  to view this content.