Try this: RetVal = Shell(“<full path to python.exe> ” & “<full path to your python script>”) Or if the python script is in the same folder as the workbook, then you can try : RetVal = Shell(“<full path to python.exe> ” & ActiveWorkBook.Path & “\<python script name>”) All details within <> are to be given. … Read more
Update (2020-11-17): py2exe LIVES!!! Apparently my pessimism a year ago (see “Update” at bottom of original post) was unwarranted. py2exe released new versions in October and November of 2020, supporting 3.5-3.8 in 0.10.0.2 and adding 3.9 support in 0.10.1.0 (dropping support for 3.4 and earlier). As long as you upgrade to an appropriate py2exe version … Read more
Steps to convert .py to .exe in Python 3.6 Install Python 3.6. Install cx_Freeze, (open your command prompt and type pip install cx_Freeze. Install idna, (open your command prompt and type pip install idna. Write a .py program named myfirstprog.py. Create a new python file named setup.py on the current directory of your script. In … Read more
The way to do this using py2exe is to use the bundle_files option in your setup.py file. For a single file you will want to set bundle_files to 1, compressed to True, and set the zipfile option to None. That way it creates one compressed file for easy distribution. Here is a more complete description … Read more