Excel macro geting web data

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
Hello - I want a macro in excel 2003 or (workspace pro 6.5 or Happy Harvester2) that collects info from the web sub page, one case after another case, till done. It should put selected info in excel, each case on a different line. However, the excel "repeat" under "edit" that I am using, fails to accomplish moving to the next line; instead it repeats the first line. I have made the macro with mouse clicks, and dont understand VBA:

Desired excel result"
ADDRESS CITY OWNER LENDER CASE DATE
123 Maple | Xenia, Ohio | Able Jones | Bell Mortgage | cv1223 | 11/04/2010
380 bell st | Dayton, Ohio | Blule | Bank America | dv 3348 | 10/03/2010

Web page listing cases URL: http://www.co.greene.oh.us/pa/pa.urd/PAMW6500
Able jones cv 1223
brown cv 129
blule cv 3348

Sub page with details on one case
URL: http://www.co.greene.oh.us/pa/pa.urd/pamw2000*o_case_sum?473007

Bell Mortgage vs Able JOnes cv1223
address: 123 Maple
Xenia, Ohio 45385

filed 11/04/2010 status open
Thanks, thanks so much.
 
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