An Excel VBA script calls on a python script. The Python script accesses a different Excel file and manipulates it. When the python script is ran normally, it works as it is supposed to, but when called from Excel, it cannot find the file it is looking for.

I need to develop a tool that will be able to check text, I only care about checking words. An Excel sheet will serve as the GUI, or if you have a better idea where to place it, I will be grateful. On the left there is text to be checked, on the right there is text from the pattern/template that is correct. Currently, the program is not immune to noise caused by separators, spaces, enters, tabs, and double spaces. Maybe someone was developing a similar text analyzer. I want him to mark repeated words in green.

I need to develop a tool that will be able to check text, I only care about checking words. An Excel sheet will serve as the GUI, or if you have a better idea where to place it, I will be grateful. On the left there is text to be checked, on the right there is text from the pattern/template that is correct. Currently, the program is not immune to noise caused by separators, spaces, enters, tabs, and double spaces. Maybe someone was developing a similar text analyzer. I want him to mark repeated words in green.

I’m trying to get this code to work. It essentially highlights specific text on another PDF, but I want the percentage of text it highlights to be returned to an Excel cell. I tried running it through the command prompt, but it wouldn’t work either. I call the code like this:

I was hoping to be able to write a python or VBA script that would go through a two column list (Full Name, Company), and return an updated sheet with each person’s CRD number, City and State.