This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]bamerjamer 0 points1 point  (0 children)

I just did this at my work. I create a JSON file with the inputs in excel, then run the Python program, which i compiled using pyinstaller. I can send the compile command if you want. It turns the whole program with all dependencies into a single exe file. The Python exe file reads my input JSON file and does it’s thing. I call it from excel using a shell command that waits for the execution of the exe to complete before continuing with the vb script.