1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Copy web data to excel

Discussion in 'Business Applications' started by GeorgeKeen, Dec 23, 2010.

Thread Status:
Not open for further replies.
  1. GeorgeKeen

    GeorgeKeen Thread Starter

    Joined:
    Dec 23, 2010
    Messages:
    2
    I am very new to excel macros, though I make frequent use of excel. 10 years experience.
    VBA is foreign to me. Question is: how do I make a macro to click on first case number on a web page, then bring selected data from a mozilla web display of the details about that case to a row of excel?
    Also, need then to return to web page, use go back on browser to previous page which is a list of court cases, by the case no. only, and drop down to the next case, click on it, then select same data fields from the next case, and transfer it to next line in the excel sheet? Continue till run out of cases on the page listing the case numbers. The data when transferred should look like the 2nd item unde the headers. I successfully made a little macro that puts the headers on the exel sheet.

    The answer may involdve something I am doing. The macro will transfer successfully when I transfer only one data item. however, when I try more, it puts the last item copoied into all the fields.
    I am running on xp, windows 8, excel 2007, Mozilla, though I have IE 8 also.
    Thanks for any help you can give me. I have successfully used the query in excelll, but thought this would be better.
    LENDERADDRESSCITY ST ZIPOWNERDATECV#2010 CV 11112010 CV 1111Pict
    2010 CV 1111Pict Pict

    2010 CV 11112010 CV 11112010 CV 1111JPMORGAN CHASE BANK NA1931 NEBRASKA DRPict
    XENIA, OH 45385Pict Pict

    FUGATE, STEVEN D10/15/20102010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 1111886 LOUISE DR

    886 LOUISE DR886 LOUISE DR886 LOUISE DR886 LOUISE DR886 LOUISE DR



    General Inquiry [​IMG] CIVIL - Summary

    2010 CV 1108 JPMORGAN CHASE BANK NA VS. HENDRIX, ROBERT K et al SAW Plaintiff(s) Defendant(s) JPMORGAN CHASE BANK NA HENDRIX, ROBERT K Attorney(s)Attorney(s) Full NameTAULBEE, MATTHEW A AddressLERNER, SAMPSON & ROTHFUSS PO BOX 5480 City/State/ZipCINCINNATI OH 45201 Phone Full Name Address City/State/Zip Phone F FORECLOSURES Additional Fields FORECLOSURE ADDRESS 886 LOUISE DR FORECLOSURE CITY/STATE/ZIP XENIA, OH 45385 LEGAL ADVERTISING NUMBER - AMOUNT RECORDER FILE NUMBER - AMOUNT Case AttributesNumber2010 CV 1108 StatusOpen Filed10/15/2010
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/970261

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice