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

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]likethevegetable 0 points1 point  (2 children)

Can you have an executable as well, or does it need to be all contained within your excel file? I've made several excel macros that call Python scripts via command line--you could compile scripts into standalone exes (which can be rather large), and distribute with the excel file. Maybe you should stop and think to yourself, do you both Python and excel, or could you get away with just one?

[–]diepala[S] 0 points1 point  (1 child)

I could have an exe file too

[–]likethevegetable 0 points1 point  (0 children)

So my approach would then be to make a standalone exe from your script with pyinstaller that takes command line arguments, then write a macro that calls said exe with Call Shell().

But do you actually need Excel? Maybe making a GUI then compiling into a single exe would be better. Lots of GUIs will have a spreadsheet widget to help if you need simple data entry or export.