Microsoft integrates the Python programming language into Excel - SiliconANGLE
Microsoft integrates the Python programming language into Excel - SiliconANGLE
siliconangle.com
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
will this kill VBA ?
- Thread starter daveyc18
- Start date
siliconangle.com
Excel Facts
Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Larry Haydn
Board Regular
- Joined
- Jul 18, 2019
- Messages
- 207
- Office Version
- 365
- Platform
- Windows
I am thinking the addition of Python will be expanded functionality in the areas of data-mining and machine learning.
It should not replace VBA - not by a long shot.
It should not replace VBA - not by a long shot.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,974
- Office Version
- 365
- Platform
- Windows
Every now and then someone sounds the alarm that VBA is going away, that either Microsoft is going to remove it or something else will replace.
However, that always is refuted by those in the know. Microsoft has no plans to remove VBA in the near future, and it is so imbedded in things that people have developed over the years, I don't think it would be quickly replaced by anything else.
So I think it is safe to say that it is still going to be around for a long while.
However, that always is refuted by those in the know. Microsoft has no plans to remove VBA in the near future, and it is so imbedded in things that people have developed over the years, I don't think it would be quickly replaced by anything else.
So I think it is safe to say that it is still going to be around for a long while.
Upvote
0
Larry Haydn
Board Regular
- Joined
- Jul 18, 2019
- Messages
- 207
- Office Version
- 365
- Platform
- Windows
In terms of Excel functionality, nothing beats Excel VBA.
Python just provide additional functionality for big data, data mining, and analytics.
Upvote
0
It needs to be understood that this python contemplated here runs through Azure, which, to my mind, is hugely problematic for work purposes... we can't put client data on external servers ('the cloud'), so it's a non-starter as far as I'm concerned
Python running locally is a different matter, and arguably would run faster than VBA, but does it have the same capabilities as VBA? No. Not even close.
For one, you cannot save python code in a workbook, send it to someone, and have that code execute. Second, python doesn't allow you to take advantage of any of the user interface fixings available through VBA - like userforms, buttons, textboxes, images, etc etc etc.
People have been saying VBA will die for decades... it still hasn't.
Upvote
0
Similar threads
- Question
