how is python different than the program that I run on msexcel macros

Answer 1

Very, if it happens to be Visual Basic for Applications (VBA).
None, if you use xlwings - an open source Python for Excel ;)

Answer 2

As Kuba said, VBA and Python are much different.

If your concern is if you're able to learn Python easily, then I would say it'll be very easy if you already know VBA.