Results 1 to 2 of 2

Thread: VBA Code For Extracting Data From Webpage In HTML5

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    1
    Rep Power
    0

    Lightbulb VBA Code For Extracting Data From Webpage In HTML5

    Hi,

    I am extracting data from IMDb - Movies, TV and Celebrities, they are using html 5 where all the codes are tagged with itemprop, I have tried the get element by id or by class name but nothing working......,
    for example:
    ---
    actor 1
    Now, the problem is Doctt.getElementsByClassName("itemprop")(11).inner HTML, is working but its not giving me accurate data
    have tried ie.document.getelementbyclass and ie.document.getelementbyclass

    --------------------------

    Also, for runtime, the code

    i am not able to understand what to write to get accurate data... in this i have tried something like..

    Doctt.getElementsByID("time itemprop=""duration""")(0).innerHTML
    Doctt.getElementsBytagname("time itemprop=""duration""")(0).innerHTML


    but its not working, please please please please advice.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Did you try going through the elements 'infobar' and 'descriptions'? And after you capture these, maybe loop through the elements within those two.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 6
    Last Post: 06-01-2013, 03:24 PM
  2. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  3. VBA Code to Extract data
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 07-24-2012, 11:37 PM
  4. Extracting Unique Data
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 07-17-2012, 09:42 PM
  5. Replies: 2
    Last Post: 04-08-2012, 09:42 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •