+ Reply to Thread
Results 1 to 4 of 4

OCR Data extraction with VBA from Web site

  1. #1
    Registered User
    Join Date
    09-07-2017
    Location
    Chile
    MS-Off Ver
    2016
    Posts
    4

    OCR Data extraction with VBA from Web site

    Hello everyone

    I have the following macros to get internet data, but, I do not know how to apply ocr to get the value that I need (price) (or if there is another way to get it)

    I would greatly appreciate your help


    Please Login or Register  to view this content.
    sorry for my english, not main language, thanks!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: OCR Data extraction with VBA from Web site

    Hello Galactico,

    I have been working on this since you posted this question at VBA Express. The spaces that are in the page source are place holders. The server side code updates these elements with the price digits. It appears to me that the Class names are associated with the individual digits. If this is proves true then a translator could be constructed.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-07-2017
    Location
    Chile
    MS-Off Ver
    2016
    Posts
    4

    Re: OCR Data extraction with VBA from Web site

    Hi Leith Ross, thanks for your reply, I tried to do this even without results, did you achieve something?

    Thank you

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: OCR Data extraction with VBA from Web site

    Cross post links :

    http://www.vbaexpress.com/forum/show...-Web-site-HELP!
    https://social.msdn.microsoft.com/Fo...office2013apps
    https://ayudaexcel.com/foro/topic/37...comment-212348

    no solutions yet - but you waste peoples time if you don't link cross posts - even the non English ones.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. OCR Data extraction with VBA from Web site
    By Galactico in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2017, 12:42 AM
  2. Data extraction
    By demahom08 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-03-2013, 11:48 AM
  3. Data extraction
    By ajlo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2013, 12:50 PM
  4. Data extraction
    By tahirawan11 in forum Excel General
    Replies: 5
    Last Post: 04-11-2012, 06:11 AM
  5. Site to Site concurrent call calculation
    By msknja in forum Excel General
    Replies: 5
    Last Post: 08-29-2010, 08:34 PM
  6. CSV Data extraction
    By Talen77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2010, 08:19 PM
  7. i made site! Good Site. Look now mysite!!!
    By joks3xxx in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 03:47 PM

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