+ Reply to Thread
Results 1 to 3 of 3

How to Pull Identical Tables to one Sheet from a List of URLs

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    New York, NY
    MS-Off Ver
    2010
    Posts
    2

    How to Pull Identical Tables to one Sheet from a List of URLs

    Hi all,

    I am looking to solve a problem that I don't think should be that difficult but I am struggling to figure out. I was able to do this pretty easily in Ruby but am looking to keep it to just Excel. I have a list of a few hundred URLs which are formatted the same with one variable. Here is an example of one of them:

    []https://www.tm3.com/tsproxy/servlet/tsmsrb?cmd=MSRB&Cusip=199491DY4&MorePrev=null&MoreNext=null&FirstSeqNo=null&LastSeqNo=null&LastTdate=null&FirstTdate=null&LastTtime=null&FirstTtime=null&startDate=null&endDate=null&startTime=null&endTime=null&minPrice=null&maxPrice=null&minYield=null&maxYield=null&minTradeSize=null&maxTradeSize=null&minSPVsMMD=null&maxSPVsMMD=null&NumberLines=25&TradeType=null

    I bolded the part that changes within each URL. This links directly to a table. My goal is to run a macro that will pull all of these tables into a single sheet. Ideally, I would also be able to add that unique indicator (the bolded identifier) to the first or last column in the table that I generate. Any help would be greatly appreciated.

    Thank you!
    Last edited by gfertel; 11-05-2012 at 03:12 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to Pull Identical Tables to one Sheet from a List of URLs

    Post an Excel example, without confidentional information, and the desired result.

    Then forummember have a better look of what you're up to.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    New York, NY
    MS-Off Ver
    2010
    Posts
    2

    Re: How to Pull Identical Tables to one Sheet from a List of URLs

    Sure, no problem. See attached. On the first tab, I have a list of two links (in reality I want it to work for hundreds. On the second tab is the data from those two links that I would like to pull into Excel.

    Cusip Data.xlsm
    Last edited by gfertel; 11-05-2012 at 03:47 PM.

+ 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