+ Reply to Thread
Results 1 to 3 of 3

import external data

  1. #1
    Registered User
    Join Date
    02-27-2007
    Posts
    27

    import external data

    I'm trying to set up some web queries. I have about 1000+ entries that I'm trying to get info for. they are all codes in the form of "XXXXX" where the X's are letters and numbers. I have a list of them and can manipulate them as needed. Each entry has a corresponding webpage in the form of www.website.com/entry="XXXXX" where XXXXX is the entry I'm looking up. Each webpage has the same format with the same tables.

    Is there a way I can use "import external data" so that the cell value is inserted in to the link? Or do I have to set up a web query for each one individually?

    Thanks,
    jed

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Are you looking at doing this via a macro?
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    02-27-2007
    Posts
    27
    I'd prefer not to. just wondering if there was something I was missing.

    -jed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1