Any (MS compatible) character recognition software that can be combined with macros?

0

Any (MS compatible) character recognition software that can be combined with macros? Any examples by chance? For example, "Take the pdf or png file, recognize the text formatting it into ascii text, import it into excel/word, process it there, so and so.."? Thanks in advance.

Answer
Discuss

Answers

0
Selected Answer

Any character recognition software puts out a file in either Text format or MS Word/Excel. Your question seems to aim at automating this process: find the source file, open it, call the conversion software, output the converted file and close the original.

Normally, such programs would be written in .NET or C#, perhaps Python. Writing it in VBA would definitely stretch MS Office's capabilities and it would be inconvenient because you would need to open an Office application before you need it, just to have access to the program.

In any event, this forum is devoted to Excel. I'm happy to inform you that your question is unrelated to that subject. Chances are overwhelming that other visitors to this forum would, like myself, be unable to assist you with the required programming even if they were willing.

On a more positive note, the task of converting a document only requires a few clicks. It's unlikely that a program could be written that would reduce the number of required clicks in a meaningful way unless you really have to process many thousands of documents. If so, I would look for automation programs from the suppliers of character recognition software.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login