Results 1 to 9 of 9

Possible for VBA to to OCR embedded picture objects and copy text values to cells?

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2003
    Posts
    8

    Possible for VBA to to OCR embedded picture objects and copy text values to cells?

    Thanks in advance to anyone who can help me with this. This is cross-posted without any responses as of the time of this post, at:

    https://www.mrexcel.com/forum/excel-...ues-cells.html

    My Excel 2013 worksheet has several embedded pictures of numerical values that have been obtained from a PrtSc of another application. Using VBA, the images are then pasted from the clipboard, named, and cropped to include only a single number with decimal point (ex: 123.4). I'd like to go a step further and have their values automatically pasted into cells. But without a method of OCR, I have to manually type the values into the target cells in order to perform further calculations from which they are based.

    Is it possible to OCR these named picture objects, such as via MODI or OneNote? My workbook is intended for distribution and use on a secure network, so installation of a 3rd party OCR application may not be possible.

    I've tried to do my part to figure this out by an extensive Google search and am led to conclude that nobody has posted a solution to the specific concept I'm after.

    Everything I gather about OneNote is that I could use VBA to execute the application but cannot continue with VBA to perform the OCR and transport the results back to Excel. Please correct me if I'm wrong.

    Microsoft has made MODI available again, so I installed it and have added a VBA Reference to the "MODI 12.0 Type Library". My attempts at reverse engineering MODI-specific VBA commands I've found on the web have either done nothing, given errors, or crashed Excel.

    So, my thought is this concept just isn't possible, but please only confirm this if you know for sure. Otherwise, any solutions or resources are greatly appreciated.
    Last edited by jasonfromchico; 07-22-2017 at 01:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Modify VBA to insert picture embedded in file instead of a link to a picture
    By edthedrummer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2017, 02:12 AM
  2. Viewing the text of a cell through an embedded jpg picture
    By Richard Buttrey in forum Excel General
    Replies: 19
    Last Post: 04-16-2016, 05:43 PM
  3. Replies: 3
    Last Post: 01-13-2012, 12:11 PM
  4. Embedded Objects on Userform
    By vincentus84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2009, 07:32 AM
  5. Embedded objects
    By Mike25 in forum Excel General
    Replies: 1
    Last Post: 03-23-2006, 10:10 AM
  6. Embedded Objects
    By Lightfoot in forum Excel General
    Replies: 0
    Last Post: 12-30-2005, 10:25 AM
  7. Copying Embedded Objects
    By jmoseley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2005, 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