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

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.