+ Reply to Thread
Results 1 to 4 of 4

Macro to automatically convert prt scr image-based text to real text in cell

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

    Macro to automatically convert prt scr image-based text to real text in cell

    I need my Excel VBA Macro to do OCR (text recognition) from a prt scr screen capture image and input the text into cells. Currently my Excel file has a push-button, and upon clicking on it the macro pastes into Excel the current clipboard image I have created by pressing prt scr while in another program. The macro then crops the image to the region with the applicable text. I have to then manually type the text I see in image format into the appropriate cells.

    Can someone help me with the VBA coding to automate this? I’d like it to use the clipboard image and run it through OneNote OCR, after which the applicable text values are automatically entered into the cells. Ideally the code will first crop to the region with the desired text before it does OCR. If this is not feasible, it will need to incorporate a method (keyword search?) to hone in on the desired text after the entire prt scr image has been OCRed.

    Thank you.

  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: Macro to automatically convert prt scr image-based text to real text in cell

    Hello jasonfromchico,

    Welcome to the Forum!

    OneNote is not easy to control with VBA as OneNote is a web based application. The controlling code is all XML. The object model is available online but I have not seen anything directly related to using the OCR .
    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
    03-21-2014
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Macro to automatically convert prt scr image-based text to real text in cell

    What about another method of OCR that doesn't require a 3rd party program, such as Microsoft Office Document Imaging (MODI)? I read it is defunct but still possible to use for OCR.

  4. #4
    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: Macro to automatically convert prt scr image-based text to real text in cell

    Hello jasonfromchico,

    Perhaps, you could. I have never heard of "MODI" until now. Couldn't sat wht versions of Windows and/or Office it work with either.

+ 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. Macro to automatically change chart line style based on cell text
    By NUMagpie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2013, 04:30 PM
  2. Replies: 4
    Last Post: 01-13-2013, 08:56 PM
  3. Macro to convert cells to text or value based on date change
    By simpson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2012, 09:47 PM
  4. Code That will Automatically convert a cell's text to Capital...
    By Mhz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2007, 10:57 AM
  5. How do you convert numbers to real text
    By Harry in forum Excel General
    Replies: 5
    Last Post: 01-26-2006, 10:25 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