+ Reply to Thread
Results 1 to 2 of 2

Help modifying someone else's VBA screen scraper

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    34

    Help modifying someone else's VBA screen scraper

    Hi Guys,

    I posted a malfunctioning version of this a while back but luckily enough the original builder updated it to make it work perfectly.

    What i was hoping was to get some help modifying it to perform the task it already does but in a loop with changeable time intervals between each iteration. Also the way it works is to create a new sheet for each "scrape", in the loop i was hoping to get i was wondering if it was possible to get scrape 2 under scrape 1 and scrape 3 under 2 etc on each sheet?

    I have attached the original workbook so the above should make sense if you run it once.

    Basically at the end I would be very happy if i could start the loop in the morning and have it run the scrape every half hour (or any other interval of my choosing) until i stop it with each sheet containing the blocks of info in the order they were scraped.

    Hopefully my post is clear, if not ask and I'll try to clarify

    Cheers guys.

    OddsChecker Horses v0.14.xlsm

  2. #2
    Registered User
    Join Date
    04-04-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Help modifying someone else's VBA screen scraper

    Ok scrap that, I'll try work it out somehow..

    for the moment i'm doing it manually which is fine, one small problem im having is that it won't import tables with over 15/16 rows for some reason. Can anyone help on this much simpler problem =)

+ 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