Python

[Russk68]

Can Python be used in place of VBA?

 

[Ezguy4u]

I kind of asked a similar question.

Selling a VBA program

I have a question that isn’t directly associated with excel, but maybe somebody has experience with this and can give me some guidance. Question; what if I come up with a vba program attached to my excel workbook/worksheet, and I believe it might have some commercial value. The vba program...

www.mrexcel.com

 

[Dan_W]

Yes and no. As always, it depends...

With the PyWin32 library, Python is able to take advantage of COM technology and interface with Excel and other COM-capable software and do much the same things as what VBA can do. It doesn't have all the advantages of VBA, but what it does offer is usually enough for most people. Sigma Coding on Youtube offers a series of videos showing you how to use Python to access Excel / VBA:

Alternatively, you can use xlWings, Pandas, or OpenPyXl

 

[Russk68]

Yes and no. As always, it depends...

With the PyWin32 library, Python is able to take advantage of COM technology and interface with Excel and other COM-capable software and do much the same things as what VBA can do. It doesn't have all the advantages of VBA, but what it does offer is usually enough for most people. Sigma Coding on Youtube offers a series of videos showing you how to use Python to access Excel / VBA:

Alternatively, you can use xlWings, Pandas, or OpenPyXl

Thank you!