Results 1 to 6 of 6

Thread: Multiple URL's to Get External Data

  1. #1

    Exclamation Multiple URL's to Get External Data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    In your post at http://www.mrexcel.com/forum/excel-q...rnal-data.html, you mention that you are using Excel 2016 for Mac.

    What precisely do you mean by "a get external data query each in a new worksheet"?
    What do you expect to find at the other side of those URL's?

    Do you want the result to be ~300 other worksheets?

  3. #3
    Each url contains a different table of data which is regularly updated.

    As such I want each url to get external data in a new worksheet (or even workbook if its easier). Therefore yes I want 300 worksheets.

    The only way I know so far to do it is save each url in text as a .iqy then get external data, but as you can imagine doing that 300 times isnt desirable.

  4. #4

  5. #5
    I'm way out of my depth here, I'm not sure what an .iqy is. But you should be able to automatic the process of creating them from cell values.

    Between AppleScript and VBA there you should be able to get this done.

    If creating an .iqy is something outside of Excel, you might want to inquire about using AppleScript at http://macscripter.net

    (BTW, they would appreciate if you let them know that you've asked about this elsewhere and post links back to the other threads.
    Read this about how to cross post politely. http://www.excelguru.ca/content.php?184)
    Last edited by mikerickson; 2016-10-14 at 01:48 PM.

  6. #6
    Thanks both for your help, all working now thanks to the advice in the crosspost.

    Apologies for cross-posting, I was unaware of the standard etiquette.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •