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.

Excel macro geting web data

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

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

    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.
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    What program did you actually create the macro in? Can you post your existing code?

    Rollin
     
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/971365

  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