Copy web data to excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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



[FONT=Arial, Helvetica, sans-serif]General Inquiry [/FONT]
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top