Hello,
I have been trying to get my python script to run in vba all day, but to no avail. I am using python and xlwings to write the data to the sheet, and I have used PyInstaller to create the executable, and finally Shell to call the path in vba. The Python script works when running it in Pycharm, as well as the executable - they both return data in excel, but my vba code just open the python terminal like it should, but doesn't return the data in a sheet. Am I using shell correctly?
Call shell("C:\Users\newUser\myPath\myfile.exe")
I have been trying to get my python script to run in vba all day, but to no avail. I am using python and xlwings to write the data to the sheet, and I have used PyInstaller to create the executable, and finally Shell to call the path in vba. The Python script works when running it in Pycharm, as well as the executable - they both return data in excel, but my vba code just open the python terminal like it should, but doesn't return the data in a sheet. Am I using shell correctly?
Call shell("C:\Users\newUser\myPath\myfile.exe")
