- Create a button via Developers Tab. If Developer Tab is missing: 1.On the File tab, go to Options > Customize Ribbon. 2.Under Customize the Ribbon and under Main Tabs, select the Developer check box.
- Also you have to save file as xlsm (Excel supported with Macro Commands)
Paste Code in VBA area. Set up your file locations. (python location + python file) Or set up location of .net in path mode + .exe file with .dll
Enable Always Run Macro: 1.Click the File tab. 2.Click Options. 3.Click Trust Center, and then click Trust Center Settings. 4.In the Trust Center, click Macro Settings. 5.Enable all macros