👉 *Check out **squarespace.com/chandoo* to save 10% off your first purchase. ⏱ *Timestamps* for the video: 0:00 - Introduction & 6 parameters 0:45 - Ease of learning (parameter 1) 1:27 - Immediate application (2) 2:55 - How many places can we use the language? (3) 3:49 - Forgiveness of a language (4) 4:41 - Availability (5) 5:30 - Automation ability (6) 6:58 - So which one to learn? 8:55 - Advice for people who are NOT yet a data analyst 10:06 - Advice for people who are already a data analyst 10:40 - What about other programming languages? 12:09 - Where to learn either Python or VBA?
Thanks Chandoo. Good advice all around. I spend most of my day inside EXCEL, so VBA is a natural fit for me. But, would like to learn Python for fun and to expand horizons and knowledge. Thanks for your insights.. always appreciated :)) Thumbs up!!
Thanks a lot for clearing the confusion between these two languages. I would go for VBA. You're the best and your explanation is very learner-friendly. God Bless you :)
I agree with your point of view regarding someone who's starting to become a data analyst and someone who's already doing the job. In my work, I tried learning Python but wasn't really able to retain the knowledge because I was learning for the sake of learning and wasn't really applicable to my job. Whereas with VBA or at least basic macro, I was able to accomplish a lot of improvements because we are already using MS Office.
Well said! The best thing is, once you know something, you know it. So you will have free time to learn other things. After you have the necessary VBA skills, you can go and learn Python / M / DAX or something else altogether. All the best. 👍
Great video! Thanks for sharing your opinion. I could not agree more. Sadly Python is rarely allowed in companies, while VBA gets you going fast and without any additions to Excel. In addition, VBA allows me to let other colleagues use my code without installing python or anything else. Of course, you could also package a .exe with python, but in many cases, the internal IT blocks most .exe files from running.
I have watched all your videos and in my opinion your doing a great stuff by educating us on BI, VBA and excel learning's.. I am very grateful to you because I have learnt many things from your youtube videos... Thanks for making us educating on these programming..
Great video! I first learned VBA but realize it was very limited to the MS Office, and I wanted to do more than that. Then I learned Python and actually never looked back. I tried to use Python whenever I need to automate Excel or data related things. That said, I totally agree that programming languages are just tools, and we as users have to decide what's the right tool to use for a given case.
I would've probably done the same. Except where I work (highly regulated industry), Python is next to impossible to get installed on your machine. VBA is right there.
@@drdeepee2503 I understand some companies don't want to take the risk, but I think they need to understand what risk is involved before making the decision to ban it. I work in insurance, which is also a highly regulated industry, and we are allowed to use open-source tools like Python or R.
I'm switching over to Python from learning R. Seems to be a little more useful. Once I was able to download a PDF, scrape it, and then insert that data into the database I realized how powerful these tools really are.
I previously dabbled with R too (you can see my R for Data Science book in the video). I agree that Python makes some of the routine tasks amazingly fast and automated. All the best.
Great video as always! I love the point about formulas being coding. I always try to do something in excel first with formulas before I turn to VBA because VBA raises the complexity for most users.
Hi Chandoo, I am completely from non tech background willing to learn to code in finance analysis field. Your videos gives a real clarity and are of great value.
if you are brand new to programming, learning python via simple 2D games is fun and object oriented. Learning a simple language and basics like functions, variables, classes (objects), and oop allows you to pick up a new language fairly easily, just learning syntax and a few workflow differences.
thank you, this was a humble sharing in terms of both VBA and Python. I like the statement to be open minded and learn whatever comes along and then use it as needed or as chosen.
Indians being solving modern problems like heroes . a big thanks to every Indians programmer and teachers In youtube, XDA, every platform. you guys are amazing and for sure one of the intelligent people in the globe
I followed your advice six months ago, and I'm very glad! I was interested in learning a coding language for data handling in my job. I went with VBA because you said that those of us using Excel will have an immediate practical application. That was very true. I took three VBA courses and now I'm far more advanced in Excel than anyone at my 400 person company. And now I'm learning Python with the right perspective! I'm so glad I followed your advice and got that foundation with VBA. Thank you so much!
Hi chandoo , thanks for the honest and unbiased inputs.honestly, I will follow your inputs and choose VBA after a huge state of confusion . Really appreciate . I request you to make a video on books vs video to learn any programming language / skills from your perspective .
Thanks Chandoo.. It is great learning.. I have shared ur video's links with my friends who actually need them. You have great skills.. Keep up the good work.
i think VBA is better depending on skill level and what goal you're trying to accomplish. macro recording automatically writes your VBA code for you when doing simple tasks. as far as i know, you can't do that with python :) (would be amazing if you could though)
Tbh no, Office Scripts is based on JavaScript. I guess Microsoft is moving towards that more than Python. But python still has tons of packages that work with excel.
VBA is really great if you want to automate while you are in and using, for example, Excel or Word. Python is great for automating from outside Excel or Word. In Python from the outside you can run Word or Excel macros, so when you actually open Excel or Word, you will be looking at the finished result. No requirement for the user to press buttons.
The domain is also important.for example If we take finance industry then anyone who works in financial modeling then VBA is non negotiable and if the person is in trading then nowadays python is the must
Very good point. That said, most people will go thru a few domains in their life. I started off in Pharmaceutical, then went to insurance, then to tech, and now do a bit of HR.
Good advice - personally, I would agree that if you are working in a corporate environment where Microsoft products are used, learning vba is a terrific and efficient use of time. Advanced excel skills, including vba and also as you note, working with formulas, may be enough to super - charge your abilities and dramatically improve your productivity. Python, on the other hand, gets you involved with many applications outside of Microsoft. If you want to be programming more generally, it seems like python would be superior. However, not everyone will want to do this sort of more general programming - and if you do, basic python skills are really just the tip of the iceberg. The only slight caveat to this relates to indenting- for a beginner, it can be frustrating to deal with python’s fussiness about indents. This can distract from other learning as your code can break for indenting reasons. Vba doesn’t have this characteristic, so it may be a better language to start with.
Hi chandoo, As python is now available in Excel could you please try to create new videos on this topic as i know the basics of both vba and python. And i use everyday vba towards my office work
Hi chandoo, I m working in shipping industry all my daily works are in Excel like (data extraction, Data cleansing, after cleaning need to filling gap using lookup formulas , after filling gap need to organizing data, Data Transferring to msword template and also consolidation), and i handle VBA which already created if is there any error occurs while running means my team mate (now he left from my company) guided me, so i can able to debug existing vba code. In my project my company using Excel only. Right now no one know VBA in my team, mostly all our teammates are doing repetitive tasks every day. Now i m planning to learn VBA or Python or RPA. i m not that much good in coding (I Know basic SQL, PLSQL) could you please suggest me which one i need to learn right now.(if i learn VBA is that good for future? or directly can i learn python or RPA tools?) When i research I came to know RPA tools like Uipath have a drag and drop option and that RPA tools also automate excel tasks, do's RPA tools can able to automate my daily works which I said above? I m in confusing stage please help me to take currect decision.
Learn whichever you want/need or is more immediately first - then 6 months later learn the other - the skills you acquired learning the first are almost directly transferrable to the second. So you don't lose either way. If you work in a company that uses Excel a lot (and so many many companies still do) then maybe prefer VBA first. If not, if you want a little extra flexibility, learn Python first. Learning a second similar OO language will take a fraction of the time of learning your first. You'll be coding in your second language in no time once you've mastered your first. That's why so many coders know several languages. It generally gets easier to pick up new languages as you go on. I know a guy who is proficient in Java, C#, C++, Python, Javascript, VB, F, Ruby, as well as knowing CSS, HTML and PHP as well as anyone I know - and legacy languages like Pascal, Cobol, Lisp and Fortran. When a new dialect comes out like Kotlin - he's coding to a staggeringly good standard in it inside one or two days. TLDNR? It matters a lot less than most people think.
A great feature of VBA is you just know how use formulas and functions in Excel and record Macros, and it will convert into a VBA program itself.. there's no such a thing in Python related to Excel
Chandoo hi, This comparison is so useful and applicable. However, you could make your tutorial enrich if you had added some screen examples which can be seen the functionality of two programming languages. Thanks
I did indeed watched "Programming with Mosh", and I really enjoyed how he explained it. Chandoo, thank you very much for the videos. I really appreciate your efforts. The organization I worked 90% uses Microsoft office so, I feel like I need to learn VBA and Macros. Can you kindly me tips on where I can learn VBA and Macro basics?
You are welcome. Reg. C# I don't think so. If anything, Office Scripts might try to replace VBA, but it is a steep hill to climb and I am not betting on it either.
PLEASE I have the project of getting some data from a dynamic website(which updates in realtime) to excel & further to process it for the result that can help me to take the decision- in this condition which is better -python or VBA? PLEASE
Hi, Great video...but you compare Python vs VBA. What about comparing to Visual Basic (VB)? I'm an old school developer. Started with Clipper in the DOS days, then moved to Visual Basic when coding for Windows. It's been 20 years since coding, but I've still retained my logic skills. I'm used to (and believe in) strong typing and coding rules. Sounds like Python (also being an interpreter not a compiler) is very lose and unstructured...which IMO sounds like a difficult task to debug, especially if you're working on someone else's code. For example, not having to declare a variable and its type, and just start using a variable anywhere in you code. Doesn't sound right. And how do you know if that variable is Global or local? I also don't see programmers using naming conventions to name their vars to their intended type (ie, cName is a char, nCount is numeric, aList is an array, etc.) Now...not to sound too old school, I do recognize that Python has been around for a long time, widely used , and very popular. So there has to be something I'm missing. Thoughts? Ideas? Comparison to VB and not VBA? Thank in advance.
Coincidentally, I too started my programming journey with VB (well, Basic first, then C, C++ and eventually VB). At a programming level, there is no difference between VBA and VB. Having used Python extensively during the last year (2022) I find that the variable scope is a dicey thing to get right. But not having to declare them makes the language more approachable to newbies. My kids who are 12 (last year) could start building fun games and programs in Python without needing to know any of that. So yeah, to a beginner it is a blessing, but for an experienced coder, this can be painful to watch.
@@chandoo_ Hey, excellent answer. So I’ve become a frustrated old school developer …well, not that old school… :). So based on your experience, is Python just coding for the “lazy” or those “who are looking for an easy way for a means to an end?” Tough to say when so many big companies are using it…though they don’t say where they use Python and if it’s used for critical mission projects. I like the idea of cross OS development, but seems like so many hoops and plug-ins to use for it to get even close to a strongly typed and mature language. So bottom line: VB or Python? I don’t believe VB is cross platform to MacOS…or is it? Tnx.
I got my nephew a Raspberry Pi for Christmas a few years ago and learned some very basic Python. I realized that it looked very similar to how my recorded macros look in excel and learned that it was actually a programming language called VBA. I now use VBA extensively at work and likely would not have gotten my recent promotion without it.
Is VBA easy to learn for non coders and is it a part of advanced Excel? If I learn VBA will python be easy for me? I am a mechanical design engineer with no programming knowledge or experience.
@@6My6sT6 Learning one programming language will certainly help to learn others. I only really use VBA, but with a few google searches, and trial and error, I have been able to create code for Google Sheets scripts on a few occasions.
Sir, Can you please make a short video about Excel SQL. Is it advanced VBA ? I'm confused as some job listings (Data analysts) requires you to have SQL experience.
HI Chandoo! Thanks for the amazing share ... Could you please tell us when does the point come when we use other tools other than excel for data analysis where excel has shortcomings? I mean it could be data size or visualization anything it could be.. just let us know
If you plan to deploy your application, then VB.NET is superior to python. The VB environment is feature rich and can be deployed easily on other computers - whereas, python, is just about impossible to deploy. I know that this is not what this video is about i.e. VBA. However, I just wanted to point out that VB.NET is a great all purpose environment for creating windows applications.
There is no such thing as "BEST" site. You an see the VBA getting started video here th-cam.com/video/l0o7VMEf0yc/w-d-xo.html and if you want more, join the VBA classes I run - chandoo.org/wp/vba-classes/
Multiple languages can be used to modify the data inside a spreadsheet. However, only VBA can be used inside Excel and other Microsoft Office products.
why isn't there any practical learning books on vba? Is it that microsoft does not want people to learn vba?or is it that things that microsoft do is not that encouraging towards the vba users? Or is it that it is so useful that people who know it want to keep vba skills their trade secret?
Hi Sir, Could you please guide me how to make automation using python software. I would like to automate some repetitive task which is kind input entry in some simulation software to get the output.
Chadoo, pl. be nice and fair..pl. don't delete adverse comments..sometimes other people's comments are much informative and helpfull..pl. be open..I salute ur knowledge on excel though..thanks
@@chandoo_ appreciate your kind feedback. I guess a topic I suffer from and suppose many do, is cleaning excel files when received with poor formats. e.g. merged cells. your support in this would be highly appreciated
Sir, can a person who has no prior knowledge of any programming language join your VBA online course. I want to automate lots of repetitive task in excel and wants to ease dashboard making.
Yes. I am a Commerce Graduate. I learnt VBA - My 1st programming language. With knowledge acquired from the Courses + Google, I am able to do automation, modelling, etc.
👉 *Check out **squarespace.com/chandoo* to save 10% off your first purchase.
⏱ *Timestamps* for the video:
0:00 - Introduction & 6 parameters
0:45 - Ease of learning (parameter 1)
1:27 - Immediate application (2)
2:55 - How many places can we use the language? (3)
3:49 - Forgiveness of a language (4)
4:41 - Availability (5)
5:30 - Automation ability (6)
6:58 - So which one to learn?
8:55 - Advice for people who are NOT yet a data analyst
10:06 - Advice for people who are already a data analyst
10:40 - What about other programming languages?
12:09 - Where to learn either Python or VBA?
Beautiful ❤️
Thanks Chandoo. Good advice all around. I spend most of my day inside EXCEL, so VBA is a natural fit for me. But, would like to learn Python for fun and to expand horizons and knowledge. Thanks for your insights.. always appreciated :)) Thumbs up!!
Hi let me know the resources you referred to and master VBA
Thanks a lot for clearing the confusion between these two languages. I would go for VBA. You're the best and your explanation is very learner-friendly. God Bless you :)
I agree with your point of view regarding someone who's starting to become a data analyst and someone who's already doing the job. In my work, I tried learning Python but wasn't really able to retain the knowledge because I was learning for the sake of learning and wasn't really applicable to my job. Whereas with VBA or at least basic macro, I was able to accomplish a lot of improvements because we are already using MS Office.
Well said! The best thing is, once you know something, you know it. So you will have free time to learn other things. After you have the necessary VBA skills, you can go and learn Python / M / DAX or something else altogether. All the best. 👍
Great video! Thanks for sharing your opinion. I could not agree more. Sadly Python is rarely allowed in companies, while VBA gets you going fast and without any additions to Excel.
In addition, VBA allows me to let other colleagues use my code without installing python or anything else.
Of course, you could also package a .exe with python, but in many cases, the internal IT blocks most .exe files from running.
Thank you. Yes, that is what I found when I work at client places too.
I have watched all your videos and in my opinion your doing a great stuff by educating us on BI, VBA and excel learning's.. I am very grateful to you because I have learnt many things from your youtube videos...
Thanks for making us educating on these programming..
I appreciate that!
@@chandoo_ Thank you sir...!!
Great video!
I first learned VBA but realize it was very limited to the MS Office, and I wanted to do more than that. Then I learned Python and actually never looked back. I tried to use Python whenever I need to automate Excel or data related things.
That said, I totally agree that programming languages are just tools, and we as users have to decide what's the right tool to use for a given case.
Great @python in office
Great
I would've probably done the same. Except where I work (highly regulated industry), Python is next to impossible to get installed on your machine. VBA is right there.
@@drdeepee2503 I understand some companies don't want to take the risk, but I think they need to understand what risk is involved before making the decision to ban it.
I work in insurance, which is also a highly regulated industry, and we are allowed to use open-source tools like Python or R.
I'm switching over to Python from learning R. Seems to be a little more useful. Once I was able to download a PDF, scrape it, and then insert that data into the database I realized how powerful these tools really are.
I previously dabbled with R too (you can see my R for Data Science book in the video). I agree that Python makes some of the routine tasks amazingly fast and automated. All the best.
Great video as always! I love the point about formulas being coding. I always try to do something in excel first with formulas before I turn to VBA because VBA raises the complexity for most users.
Thanks :) I had to mention those, after all Excel is the original no (low) code programming langauge.
Hi Chandoo, I am completely from non tech background willing to learn to code in finance analysis field. Your videos gives a real clarity and are of great value.
Thank you Tanya. More power to you.
if you are brand new to programming, learning python via simple 2D games is fun and object oriented.
Learning a simple language and basics like functions, variables, classes (objects), and oop allows you to pick up a new language fairly easily, just learning syntax and a few workflow differences.
I was actually really confuse and want to start with VBA and your video pops up, i cant thank enough for this video ,, really really thank you so much
Thanks Patel. Many of my students & viewers asked me this question, so I made a video.
thank you, this was a humble sharing in terms of both VBA and Python. I like the statement to be open minded and learn whatever comes along and then use it as needed or as chosen.
You are welcome Vern.
Indians being solving modern problems like heroes .
a big thanks to every Indians programmer and teachers In youtube, XDA, every platform.
you guys are amazing and for sure one of the intelligent people in the globe
Thanks for the appreciation and love Belkacem. 😍😀
I really wanted this topic to someone address, thankyou so much Chandoo
Glad it helped Vikas :)
@@chandoo_ grateful to you for addresses this topic! Much needed at this time!
One of the most potent contents on this topic and how well executed! Thank you !!!
Glad you liked it! I had so much fun shooting and editing the video too.
@@chandoo_ thank you for your hard work to help make us smart 🤓
Thanks Chandoo.. your mentality has brought you to where you are now… well done 👍👍👍
I followed your advice six months ago, and I'm very glad! I was interested in learning a coding language for data handling in my job. I went with VBA because you said that those of us using Excel will have an immediate practical application. That was very true. I took three VBA courses and now I'm far more advanced in Excel than anyone at my 400 person company. And now I'm learning Python with the right perspective! I'm so glad I followed your advice and got that foundation with VBA. Thank you so much!
Wow.. awesome to hear that. More power to you ⚡
Hi chandoo , thanks for the honest and unbiased inputs.honestly, I will follow your inputs and choose VBA after a huge state of confusion . Really appreciate . I request you to make a video on books vs video to learn any programming language / skills from your perspective .
Because Python has libraries, it makes a lot easier to work with data... I know VBA anf Python and certainly I would choose this last one
Thanks Chandu. I am following you since decade.. Thanks for sharing for all VBA and Python information.. Looking forward and stay blessed.
Wow.. it is always a pleasure to interact with long time followers like you. Thanks for the blessings & love. 😍
your line of code to download all the comments from a youtube video was really interesting
I liked and agreed with your comments. I liked the conclusion, which was kind of a surprise.
Great information. I'm going to check out your vba videos. Thanks for the help, I've become a new subscriber!
Oh This is Chandoo. I have used your VBA. Nice to watch your video.
so far you're my favorite youtuber. thanks man!
Every sentence flowing from exprential knowledge, even many have but may not sharing, your humble explanations are awesome
Thanks Chandoo.. It is great learning.. I have shared ur video's links with my friends who actually need them. You have great skills.. Keep up the good work.
You are welcome Ashish. Big thanks for sharing and spreading the good word. More power to you.
I learn VBA since 1years because in Mechanical it is THE KING, all sofware as CATIA or SolidWOrks use VBA with Excel often xD
Didn't know that. 😀
i think VBA is better depending on skill level and what goal you're trying to accomplish. macro recording automatically writes your VBA code for you when doing simple tasks. as far as i know, you can't do that with python :) (would be amazing if you could though)
Thank you for your honest recommendation.
Chandoo is the best... long time follower of your website for vba and excel.. keep up the great job👍👍
Thanks Janmejaya... 😀
but the big question is: when is Python going to be integrated in Excel as VBA is??
You do not need Python to be integrated with Excel. Excel contains your data, Python does the processing.
There are also packages that can process / automate Excel files with Python. Just search.
Tbh no, Office Scripts is based on JavaScript. I guess Microsoft is moving towards that more than Python. But python still has tons of packages that work with excel.
Never. Microsoft is more interested in integrating Typescript (Office Scripts).
Awsome chandooo...Good comparisiion...We We should be loyal to our skills...NOT Languages/Tools...Respect from Blr....
Very good explained chandoo. Thank you so much!!!
VBA is really great if you want to automate while you are in and using, for example, Excel or Word. Python is great for automating from outside Excel or Word. In Python from the outside you can run Word or Excel macros, so when you actually open Excel or Word, you will be looking at the finished result. No requirement for the user to press buttons.
Just a great video - you are a teacher with humour! and that is a thrilling combination!
Thanks alot for this chandoo ji
Eyeopener video for me.. Thanks Chandoo.. :)
I am glad it helped Sam... 😀
Thank you very much for explaining this.
Sometimes I dream of VBA and Python Offspring
The domain is also important.for example If we take finance industry then anyone who works in financial modeling then VBA is non negotiable and if the person is in trading then nowadays python is the must
Very good point. That said, most people will go thru a few domains in their life. I started off in Pharmaceutical, then went to insurance, then to tech, and now do a bit of HR.
Thank you very much Chandoo
I want to Microsoft Office & Google sheet Automation. For this which is better for me VBA or Python? Please reply
Good advice - personally, I would agree that if you are working in a corporate environment where Microsoft products are used, learning vba is a terrific and efficient use of time. Advanced excel skills, including vba and also as you note, working with formulas, may be enough to super - charge your abilities and dramatically improve your productivity. Python, on the other hand, gets you involved with many applications outside of Microsoft. If you want to be programming more generally, it seems like python would be superior. However, not everyone will want to do this sort of more general programming - and if you do, basic python skills are really just the tip of the iceberg. The only slight caveat to this relates to indenting- for a beginner, it can be frustrating to deal with python’s fussiness about indents. This can distract from other learning as your code can break for indenting reasons. Vba doesn’t have this characteristic, so it may be a better language to start with.
Guru ... Correct me whether I am seeing Power Point when you say Access .... or it is voluntary
Hi chandoo,
As python is now available in Excel could you please try to create new videos on this topic as i know the basics of both vba and python. And i use everyday vba towards my office work
Nice to see a book recommendation, got the same but didnt read it :D yet.... after this video I made up my mind a bit! Thanks!
your thoughts always give great direction for long life distance
Hi chandoo, I m working in shipping industry all my daily works are in Excel like (data extraction, Data cleansing, after cleaning need to filling gap using lookup formulas , after filling gap need to organizing data, Data Transferring to msword template and also consolidation), and i handle VBA which already created if is there any error occurs while running means my team mate (now he left from my company) guided me, so i can able to debug existing vba code. In my project my company using Excel only. Right now no one know VBA in my team, mostly all our teammates are doing repetitive tasks every day. Now i m planning to learn VBA or Python or RPA. i m not that much good in coding (I Know basic SQL, PLSQL) could you please suggest me which one i need to learn right now.(if i learn VBA is that good for future? or directly can i learn python or RPA tools?) When i research I came to know RPA tools like Uipath have a drag and drop option and that RPA tools also automate excel tasks, do's RPA tools can able to automate my daily works which I said above? I m in confusing stage please help me to take currect decision.
Learn whichever you want/need or is more immediately first - then 6 months later learn the other - the skills you acquired learning the first are almost directly transferrable to the second. So you don't lose either way.
If you work in a company that uses Excel a lot (and so many many companies still do) then maybe prefer VBA first. If not, if you want a little extra flexibility, learn Python first.
Learning a second similar OO language will take a fraction of the time of learning your first. You'll be coding in your second language in no time once you've mastered your first.
That's why so many coders know several languages. It generally gets easier to pick up new languages as you go on. I know a guy who is proficient in Java, C#, C++, Python, Javascript, VB, F, Ruby, as well as knowing CSS, HTML and PHP as well as anyone I know - and legacy languages like Pascal, Cobol, Lisp and Fortran.
When a new dialect comes out like Kotlin - he's coding to a staggeringly good standard in it inside one or two days.
TLDNR? It matters a lot less than most people think.
A great feature of VBA is you just know how use formulas and functions in Excel and record Macros, and it will convert into a VBA program itself.. there's no such a thing in Python related to Excel
Chandoo hi,
This comparison is so useful and applicable. However, you could make your tutorial enrich if you had added some screen examples which can be seen the functionality of two programming languages.
Thanks
Thanks Emre.. Good suggestion on adding screen examples. I will do a follow-up video in a few weeks time on that.
Hey,
I have some query ..
How can I link my excel sheet with ERP oracle software..
Expecting a response on this comments from any member of author
Good advice Chandoo
I did indeed watched "Programming with Mosh", and I really enjoyed how he explained it. Chandoo, thank you very much for the videos. I really appreciate your efforts. The organization I worked 90% uses Microsoft office so, I feel like I need to learn VBA and Macros. Can you kindly me tips on where I can learn VBA and Macro basics?
wonderful conclusion dont have loyal to one program, keep learning.
Thanks for recommending Mosh. He's my instructor and he's very explicit in his teaching.
Yeah... Mosh is awesome :)
Thank you Chandoo; can C# replace VB/VBA for MS Windows/Office ecosystem?
You are welcome. Reg. C# I don't think so. If anything, Office Scripts might try to replace VBA, but it is a steep hill to climb and I am not betting on it either.
ArcGIS gives you options to use VBA, Python and SQL
Didn't know that...
Do we need to learn c programming before?
Or c++ ?
PLEASE I have the project of getting some data from a dynamic website(which updates in realtime) to excel & further to process it for the result that can help me to take the decision- in this condition which is better -python or VBA? PLEASE
Thanks for considering my comment
You are welcome Sreejesh.. Many of our viewers requested this topic. So I made a video :)
Hi, Great video...but you compare Python vs VBA. What about comparing to Visual Basic (VB)? I'm an old school developer. Started with Clipper in the DOS days, then moved to Visual Basic when coding for Windows. It's been 20 years since coding, but I've still retained my logic skills. I'm used to (and believe in) strong typing and coding rules. Sounds like Python (also being an interpreter not a compiler) is very lose and unstructured...which IMO sounds like a difficult task to debug, especially if you're working on someone else's code. For example, not having to declare a variable and its type, and just start using a variable anywhere in you code. Doesn't sound right. And how do you know if that variable is Global or local? I also don't see programmers using naming conventions to name their vars to their intended type (ie, cName is a char, nCount is numeric, aList is an array, etc.) Now...not to sound too old school, I do recognize that Python has been around for a long time, widely used , and very popular. So there has to be something I'm missing. Thoughts? Ideas? Comparison to VB and not VBA? Thank in advance.
Coincidentally, I too started my programming journey with VB (well, Basic first, then C, C++ and eventually VB). At a programming level, there is no difference between VBA and VB. Having used Python extensively during the last year (2022) I find that the variable scope is a dicey thing to get right. But not having to declare them makes the language more approachable to newbies. My kids who are 12 (last year) could start building fun games and programs in Python without needing to know any of that.
So yeah, to a beginner it is a blessing, but for an experienced coder, this can be painful to watch.
@@chandoo_ Hey, excellent answer. So I’ve become a frustrated old school developer …well, not that old school… :). So based on your experience, is Python just coding for the “lazy” or those “who are looking for an easy way for a means to an end?” Tough to say when so many big companies are using it…though they don’t say where they use Python and if it’s used for critical mission projects.
I like the idea of cross OS development, but seems like so many hoops and plug-ins to use for it to get even close to a strongly typed and mature language.
So bottom line: VB or Python? I don’t believe VB is cross platform to MacOS…or is it? Tnx.
I got my nephew a Raspberry Pi for Christmas a few years ago and learned some very basic Python. I realized that it looked very similar to how my recorded macros look in excel and learned that it was actually a programming language called VBA. I now use VBA extensively at work and likely would not have gotten my recent promotion without it.
Is VBA easy to learn for non coders and is it a part of advanced Excel? If I learn VBA will python be easy for me? I am a mechanical design engineer with no programming knowledge or experience.
@@6My6sT6 Learning one programming language will certainly help to learn others. I only really use VBA, but with a few google searches, and trial and error, I have been able to create code for Google Sheets scripts on a few occasions.
@@jrm250 Do I need to be strong in mathematical concepts like Algebra, statistics and graph theory for python or VBA?
And having excellent foundation in VBA helps you learn other programming languages a lot faster. Let's thrive in data crunching!
Bingo!!! VBA, the gateway to programming addiction since 1993.
Hello Chandoo, what is the link to your website please
Sir, Can you please make a short video about Excel SQL. Is it advanced VBA ? I'm confused as some job listings (Data analysts) requires you to have SQL experience.
I know SQL, Python, R but Vba Is the toughest coding language that I ever tried. It's so tough that it's the only coding language which I gave up.
Thanks again, Professor...
HI Chandoo! Thanks for the amazing share ... Could you please tell us when does the point come when we use other tools other than excel for data analysis where excel has shortcomings? I mean it could be data size or visualization anything it could be.. just let us know
Hi Chandoo. You will pass fr a 20 year old in this video. I thought it was your first video on TH-cam, back in the years.
Wow.. 😊
Sorry I thought because of security vulnerabilities VBA scripts is disable in most organisations?
That is not completely true.
If you plan to deploy your application, then VB.NET is superior to python. The VB environment is feature rich and can be deployed easily on other computers - whereas, python, is just about impossible to deploy. I know that this is not what this video is about i.e. VBA. However, I just wanted to point out that VB.NET is a great all purpose environment for creating windows applications.
Your every video is amazing, unlike others you are pretty honest in whatever u teach. May Allah bless you.
Sir, you did not mention charting ability in python, particularly with PBI.
Yes... that was one thing I had on my notes but skipped.
Hi Chandoo, do you know of any resources that can help integrate already created excel VBA with python?
I am not familiar with such tools.
Where can I learn VBA programming? What's the best site? I want to use VBA for outlook, excel and Word.
There is no such thing as "BEST" site. You an see the VBA getting started video here th-cam.com/video/l0o7VMEf0yc/w-d-xo.html and if you want more, join the VBA classes I run - chandoo.org/wp/vba-classes/
Can Python be used inside of Excel like VBA
to manipulate spreadsheet elements from the inside?
Multiple languages can be used to modify the data inside a spreadsheet. However, only VBA can be used inside Excel and other Microsoft Office products.
Thank you for the knowledge..
After saving pdf file how to make it open automatically?
why isn't there any practical learning books on vba? Is it that microsoft does not want people to learn vba?or is it that things that microsoft do is not that encouraging towards the vba users? Or is it that it is so useful that people who know it want to keep vba skills their trade secret?
Was Looking for this video.
😀😀😀
hello sir , is it necessary u have excel knowledge before u learn VBA?
Yes, As VBA is used to automate Office software (Word / Excel / Outlook etc.) you need the knowledge of the platform you are automating first.
decided to go to c++ to create my own VBTHON :)
Hi Sir,
Could you please guide me how to make automation using python software. I would like to automate some repetitive task which is kind input entry in some simulation software to get the output.
Chadoo, pl. be nice and fair..pl. don't delete adverse comments..sometimes other people's comments are much informative and helpfull..pl. be open..I salute ur knowledge on excel though..thanks
Well, I want to be nice too. But your comment was not adding to the discussion or helpful. You be fair too.
Does a possibility of getting employed as a data analyst prior to learning coding really exist?
Thanks chandoo👍
You are welcome Junaid... :)
Dear Sir , I would like to learn both PyThon 🐍 and VBA 😃.
Since you teach in such a simple way .
👍🏻
Regards
thank you!🙏
Thank you so much!!
Dear all,
Can you pls confirm how and from where we can learn VBA?
if I were to add R to the dilemma what would you say??? I am into data analytics, charting numbers...
The arguments are similar for R too. I would say prioritize and learn what you need immediately first and then learn the other later. All the best.
@@chandoo_ appreciate your kind feedback. I guess a topic I suffer from and suppose many do, is cleaning excel files when received with poor formats. e.g. merged cells. your support in this would be highly appreciated
Sir, can a person who has no prior knowledge of any programming language join your VBA online course. I want to automate lots of repetitive task in excel and wants to ease dashboard making.
Yes.
I am a Commerce Graduate. I learnt VBA - My 1st programming language.
With knowledge acquired from the Courses + Google, I am able to do automation, modelling, etc.
Nice information thank you so much
Thank you.
Chandoo...u have a good sense of humor 🤣😀
I love a good joke (and biryani 🥘 too).
Hi @chandoo , Can you please create a playlist just for Automation through VBA and/or python
Here it is - th-cam.com/video/nerIcLV7a2s/w-d-xo.html
This one`s mine is just Awesome...
Don't want my audience to be confused... 🤣
What are the best books for python for learners