OCR in VBA?

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I have 1000s of employee profile pictures with their respective dates printed below. I need to segregate the ones with and without dates. Right now I'm doing it manually by looking at the thumbnails in Windows Explorer, but it's really frustrating. Is there a way to get these dates into Excel? I'm a novice and I'm posting here because someone suggested OCR is possible in VBA (probably with some add-in?). Any other solution you could help me with would also be great! Thanks in advance.


    Edit: I don't need the dates as such, I just need to know which photograph has a date and which doesn't.

  • You could use Tesseract-Ocr to scan your pictures and adapt the Excel project to loop your picture folder. Haven't tested it but it could be an interesting approach for you as per this video on YouTube LINK. The OCR software you need can be downloaded from here LINK and a working Excel project can be downloaded directly from here LINK.

  • You could use Tesseract-Ocr to scan your pictures and adapt the Excel project to loop your picture folder. Haven't tested it but it could be an interesting approach for you as per this video on YouTube LINK. The OCR software you need can be downloaded from here LINK and a working Excel project can be downloaded directly from here LINK.

    Thank you very much, I did try this earlier today; followed all the steps as in the video, but for some reason it isn't working for me. All I get is "?" as a result in A1. Also, how do I incorporate file names into this? Only then could I segregate the employees.

  • In the meantime I tested it and noticed that all depends on how much the date outstand over the picture. There also minor problems with the file name, as is if it contains a space it will not be correctly considered.

    May you attach a demo picture exactly the same as the ones you are using ?

  • In the meantime I tested it and noticed that all depends on how much the date outstand over the picture. There also minor problems with the file name, as is if it contains a space it will not be correctly considered.

    May you attach a demo picture exactly the same as the ones you are using ?

    These pictures have different fonts in them for the dates (as per the employee's preference I guess) so that makes it even more complicated.

    Thankfully, someone in the organization now made it mandatory for employees to add the date into a text box while uploading their photos. Saved me some hassle. Thanks again!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!