External data still........
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: External data still........

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, I still cannot figure out how to pull data from the web without having to insert the complete URL. I want to reference PART of the URL from a cell I.E. Cell A1 to Cell A1000. I want it to do it automatically, as I have thousands of numbers to track on the internet and they each have their own web page.

    Thanks,

    Kurt

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 10:30, kurtpackard wrote:
    Hi, I still cannot figure out how to pull data from the web without having to insert the complete URL. I want to reference PART of the URL from a cell I.E. Cell A1 to Cell A1000. I want it to do it automatically, as I have thousands of numbers to track on the internet and they each have their own web page.

    Thanks,

    Kurt
    Hi Kurt,

    I am not sure I follow you, but are you going to append the specifics to a certain set website (i.e you have the main part of the URL as the constant and the detailed, secondary pages on the worksheet)?

    If so, could you use something like this in your loop...?

    setstring = (your base URL)

    For x = 1 to 1000
    yourstring = setstring & Cells(x,1)

    do something with your string

    next x

    This may be of some use.

    Regards,
    Jay

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try Downloading the Excel Web Connectivity Kit from http://office.microsoft.com/downloads
    it will give you a detailed explanation of writing queries and examples

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I am sorry I am not being very clear. I have been using Excel for a long time, but I have only used it for the simple stuff. Let me try to explain.

    I have a spreadsheet I created off of a shipping data base that in Colum A has all of the tracking numbers. I have used the extract data function sucessfully for a single tracking number, say in colum A1. What I want to do is have excel automatically track the numbers from the web. I really do not care how it gets done, as long as it gets done. Someone sent me some code, but I am not really clear on where to put it or how to implement it. I will down load the connectivity kit when I get home tonight and try that. If there are any books I could buy please let me know.

    Thank you,

    Kurt

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com