I Have column A filled with ~300 URL's (each in a new row).
I want to turn each of these URL's into a get external data query each in a new worksheet so they refresh consistently.
The only way I know how to do this is to save each url as a .iqy and to manually run a get external data on a new worksheet for each.
I was wondering if there was any way (likely vba) to automate this process?
Thank you!
I want to turn each of these URL's into a get external data query each in a new worksheet so they refresh consistently.
The only way I know how to do this is to save each url as a .iqy and to manually run a get external data on a new worksheet for each.
I was wondering if there was any way (likely vba) to automate this process?
Thank you!