Would you prefer VBA or Python for automation in Excel?
In my experience, Python is a bit more secure, and I've already messed up Excel with VBA. What were your experiences?
(3 votes)
Loading...
(3 votes)Loading...
(3 votes)Loading...Similar Posts
Are Shein and Temu reputable for ordering things?
dresses, shoes, jackets, etc.?
What does this Java method mean?
Hello, I've been given a Java method here, but unfortunately, I don't fully understand the functions and everything else. We've been given the method without any context or context, and I honestly find it difficult to describe it.
Online shopping?
ByTommi224
Hello, I wanted to order something today and clicked on "Checkout" but it didn't load and I didn't get a confirmation and now I don't know if I ordered it or not, please help. LG Tommy
Specialist work in artificial intelligence?
Hello, I recently wrote a research paper and handed it in now. To check, I used Plagiarism and AI Scanner to see what the results were. I didn't copy anything from Chat GBT and I cited all the sources where I got my information. The plagiarism scanner checked everything, but the AI scanner showed that…
How should one approach this task?
Format text • Develop a C program that reads a text file and reformats the lines. • The words contained in the file should be rewritten to a new file in the same order as they were read in, forming lines of a maximum of n > 0 characters, with maximum line utilization. The line…
JS React "react-simple-maps" – remove spacing?
Bypuoti
I have a problem where there is a gap around the Italy map and I don't know how to remove it. Code: const geoUrl = " https://raw.githubusercontent.com/deldersveld/topojson/master/countries/italy/italy-regions.json " const MapChart = () => { return ( <ComposableMap projectionConfig={{ center: [11, 39], scale: 1800 }}> <Geographies geography={geoUrl}> {({ geographies }) => geographies.map((geo) => ( <Geography key={geo.rsmKey}…
Python is undoubtedly more future-proof than VBA. While VBA is suitable for fast, small automation in Excel, Python is much more powerful and versatile. With Python, robust, safe and reusable automations can be created, something that VBA often cannot offer to the same extent.
In addition, VBA has lost importance in modern software development. Nowadays it is only rarely used as it is outdated compared to more modern technologies such as Python, Office Scripts or Power Automate.
Microsoft itself has stopped the further development of VBA. There are no new features or updates, but only security patches and bug fixes. In addition, VBA works exclusively in the desktop version of Office. There are numerous limitations on MacOS, and in the online version of Office (Microsoft 365), VBA is not supported at all.
In my opinion, it’s just a matter of time until the support for VBA is completely set, as it simply no longer meets the requirements for modern automation solutions.
So it is little sensible to invest time in learning. Thank you.
VBA has never been really practical to my experience. It was a playground, maximum for a few school xperimente or if you wanted to deal with the object model privately.
For a long time, it has been better not to automate Excel intrinsically, but to approach interfaces from the outside.
The main manko of VBA is the poor distribution. Security policies and finally own file extensions were stones thrown in the way (even if they have their permission). Then you copy the file with the macros somewhere or send it to 10 mail recipients who work on it (if it is not recognized as maleware and deleted). You recognize a mistake or want to expand the macro. What are you doing? What about the well maintained data of the mail recipients?
What does a company do when the VBA expert leaves the company?
Basically, I would try to control Excel as little as possible. It is best to store the logic and to fill Excel( templates) with data only. In the templates, the formatting should already be defined.
I just saw that Python is being introduced in Excel. Just clicked on Update. However, if I’m a business user and I’m in the insider channel, it’s funny.
From what I could find on the Internet, it looks very exciting at first glance, especially because you can apply python scripts to individual cells and as a return not only text values, but also python objects, with which you can then continue to calculate.
VBA has a few problems that quite restrict the use.
Thank you. I actually shot up office completely with VBA so that only a complete set-up of the system has helped. Since then, I’ve been doing something more with Python, it’s never happened to me.
I have never done this before, although I have developed professional applications in VBA (MS Access) for years. There were other problems. The forms used with the time and time until they could be edited (or at each click on a control element you had to wait one minute until you could edit it), when the file size has grown over 2GB, the database no longer worked and you had to hope that when compressing no data could be lost, and (sometimes) the program has suddenly issued strange error messages, and you had to recompile with an undocumented command.
In any case, I find the subscription costs are given. I’m an office man with basic programming skills, and that helped me incredibly much. Of course, I keep pushing my boundaries and then I have to learn something. That’s what I’m gonna do. But it is absolutely fascinating what I can achieve as a non-programmer.
If you’re a developer like you, it probably goes far beyond that.
Goes with ChatGPT Premium as described. The $20 a month is a joke for what you get. I’ve been automating so much that the subscription is secure for the next few years.
At ChatGPT you can select the version in the ComboBox at the top left. There are now six models, and you can add countless extensions like Python, DesignerGPT, ExcelCreator and many more. In the beginning I was also skeptical, but by now I use it as a developer daily for smaller tasks. I can only recommend you looking at it once. It has often helped me with bug fixes that I didn’t get on with.
Where can you choose different models? I’ve been trying with it a little bit. It is well suited to build a base and do the rough writing stuff, but the fine tuning must still be done by hand
Do you now use chatbots for programming? I find the O1 and O1 Mini models really good at ChatGPT. One has to give clear instructions and sometimes completely rethink when the AI does not go on.
VBA is only kept alive for reasons of downward compatibility and is hardly further developed.
Personally, I know myself well in VBA and, if at all, I am going to be very late.
I would always recommend newcomers to alternatives if there are them and are official. This is a better investment in the future.
And the more questions about non-VBA automation come, the greater the incentive for me to deal with the alternatives.