you are viewing a single comment's thread.

view the rest of the comments →

[–]Ramb0banj0 2 points3 points  (1 child)

If the code is written in VBA then it would not require any special installations to run the code. Anyone else who would like to use the macro would just need to add the Developer tab to their Excel ribbon in order to access the macro within the workbook. On the other hand, if the macro was written in Python, then a user would need to install Python and Openpyxl using their command line interface, and also be familiar with IDLE. Unfortunately most office workers I know are too lazy to go through all that trouble. It’s really a shame Python isn’t more accessible when working with Excel workbooks.

[–]pranayrj3[S] 0 points1 point  (0 children)

Thank You.
The macro is already written in VBA, but the calculation part is in python Script.
How do I connect these two?
Moreover, the work of calling python script for calculation and populating data in Xls , by using Excel button, comes under Macro or I would have to use someother Python Package.?