+ Reply to Thread
Results 1 to 8 of 8

help from web scraping

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    11

    help from web scraping

    hello everyone

    im trying to code this web scraper,
    but im having errors with getelementbyid
    this is my code

    Please Login or Register  to view this content.
    when i analyze step by step variable orgbox wont assign the htmlelement so im having errors from "OrgBox.Value = latlng"

    please i really need your help guys.

    thanks in advance

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: help from web scraping

    I did a forum search for web scraping, and came up with 28 threads in teh past year...
    http://www.excelforum.com/search.php?searchid=4822386
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: help from web scraping

    @FDibbins thanks for your reply. i tried searching but i cant find answers from my concern. i think its because the element im trying to get is from javascript function. do you think its hopeless?

    thanks

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: help from web scraping

    I have no experience with web scraping, thats why I gave you those links

  5. #5
    Registered User
    Join Date
    09-07-2012
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: help from web scraping

    Quote Originally Posted by FDibbins View Post
    I have no experience with web scraping, thats why I gave you those links
    sorry but this is what i get from your link.

    Capture.JPG

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Cool Hi ! Try this ‼

    PHP Code: 
    Sub ReverseGMAP()
        
    ActiveWorkbook.FollowHyperlink "http://maps.google.com/maps?q=" Cells(24).Value "," Cells(25).Value
    End Sub 
    Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

  7. #7
    Registered User
    Join Date
    09-07-2012
    Location
    philippines
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Hi ! Try this ‼

    sorry didnt worked. what im trying to do is fill the input box and press the button of the web site. so i can scrape the informations. thanks for helping though.

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: help from web scraping


    My code displays the same map point than with your link ‼

    So if you try to well explain …

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Web Scraping with VBA
    By Branbran10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2015, 09:30 AM
  2. Web scraping
    By vijay.jp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2015, 08:07 AM
  3. Web scraping
    By vijay.jp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2015, 12:56 AM
  4. Web Scraping
    By Thomo88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 07:21 AM
  5. New to VBA - Web Scraping
    By cringle in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 12-17-2013, 08:26 AM
  6. Web Scraping
    By redkilner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2013, 09:00 AM
  7. [SOLVED] Web scraping with xml
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2012, 05:25 AM

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