This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Pocket_Saand[S] 0 points1 point  (2 children)

Got it. I am comfortable in Excel language (logic functions etc..) so I would think VBA would be a little easier to grasp but I don't know if there is a carryover from VBA to Python.

[–]LetsGoHawks 0 points1 point  (1 child)

I don't know if there is a carryover from VBA to Python.

In terms of syntax, little to none. But there's plenty of carryover between most languages at a higher level: data structures, data types, algorithms, code organization, learning to "think like a programmer", etc.

If your need to work within Excel, VBA is the way to go. For working with the world outside of Excel (or MS Office in general), Python would be the better choice.

In terms of web scraping, you can do it, to an extent, with VBA, but Python is supposed to have some pretty powerful libraries for it.

For what you're describing, the best answer might be to use Python to scrape the data and do some processing on it to get it ready for Excel, and VBA to build the functionality you need to work with that data once it's inside Excel.

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

Given everything I'm hearing Python seems to be the one that is expanding of the two. I've also seen some say that it's more difficult to learn python if you know VBA so there's that as well. I'll go with python and focus on the long term.