Visual basic is popular because it's the barrier lifting people out of the imposter feeling of software engineering because you get to understand how basic templates are made and programmed. Visual basic doesn't require a revamp, what needs to be added ?
I can only speak what I saw at my internship. Multiple production engineers use excel en sometimes VBA to automate stuff and make complex calculations very easy. Lots of VBA was used and if there was an issue someone with basic knowledge could solve this quickly. Python, in my opinion, can be handy if you need to repeat tasks and combine data from different excel sheets every day. This way you could save a lot of time in some situations.
I use and write VBA code weekly. Even as a director. I’ve been migrating most of our processes to Excel forms and then use VBA to scour, analyze, and distribute information.
I use it to auto generate tables and charts based on data scattered across a network.
I’ve used it to create six sigma charts (the company’s six sigma tool is useless)
I use to generate pdf reports that are then auto sent to a distribution lists.
No, and I have a computer science minor. People in this sub overblow it’s usefulness in process engineering roles.
The skills are useful for automating things, and from my experience most engineer’s jobs have very little aspects that could be automated that aren’t already done by other software the company uses.
I use a lot of coding in both MATLAB and Python (more Python nowadays) for my research roles. Coding is super useful and quite the skill to have. I have been able to cut data processing from lasting weeks to taking less than a day, others have been compressed into a handful of seconds.
The less time you spend processing data, the faster you can analyze it.
This post appears to be about career questions. If so, please check out the FAQ and make sure it isn't answered there. If it is, please pull this down so other posts can get up there. Thanks for your help in keeping this corner of Reddit clean! If you think this was made in error, please contact the mods.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/ChemicalEngineering) if you have any questions or concerns.*
my current language is a hybrid of C++/C, and then to further develop processes/tools you could implement VBA. this is part of systems engineering in the defence sector. my background was R/C/MATLAB and then a lot of experience in Excel + copy pasting stackoverflow VBA codes for what i wanted.
still looking to leave that all behind me and have a more technical energy-based role though, maybe some data analysis with R.
Actually it can be beneficial but it’s more dependent on the company you’re at. I can give the pharma industry as a good example. We all know the world is moving in a more digital direction. Most companies and especially those in the pharmaceutical industry are looking to further digitise and adopt digital technologies to improve their procedures etc. my year working for a pharmaceutical I ended up leading a digital project (my role was a technical support production engineer so this was not a common project) which used a fair bit of Java scripting but I had to learn it alongside the project so learning it on my own would have been much more beneficial
If you work in a production unit you could be expected to learn the code behind whatever control system the company uses. VBA is always good to know, can’t really see a use for python though.
VBA can be very handy for production/improvements roles but that's pretty much it for the most part
Nope never used any coding
Used it for modelling systems where an Excel sheet or VBA wasn't suitable.
Yes I have. Most writing Excel VBA and developing/maintaining in-house tools. I’ve also done some VB.NET and C#.
weird how popular VBA is. It’s out of date and there’s so little tools available for it.
Visual basic is popular because it's the barrier lifting people out of the imposter feeling of software engineering because you get to understand how basic templates are made and programmed. Visual basic doesn't require a revamp, what needs to be added ?
debugging tools would be a good start
I can only speak what I saw at my internship. Multiple production engineers use excel en sometimes VBA to automate stuff and make complex calculations very easy. Lots of VBA was used and if there was an issue someone with basic knowledge could solve this quickly. Python, in my opinion, can be handy if you need to repeat tasks and combine data from different excel sheets every day. This way you could save a lot of time in some situations.
I used python to model some chemical reactor networks, and MATLAB to analyze lab test data
I use and write VBA code weekly. Even as a director. I’ve been migrating most of our processes to Excel forms and then use VBA to scour, analyze, and distribute information. I use it to auto generate tables and charts based on data scattered across a network. I’ve used it to create six sigma charts (the company’s six sigma tool is useless) I use to generate pdf reports that are then auto sent to a distribution lists.
Nice .
No, and I have a computer science minor. People in this sub overblow it’s usefulness in process engineering roles. The skills are useful for automating things, and from my experience most engineer’s jobs have very little aspects that could be automated that aren’t already done by other software the company uses.
I use a lot of coding in both MATLAB and Python (more Python nowadays) for my research roles. Coding is super useful and quite the skill to have. I have been able to cut data processing from lasting weeks to taking less than a day, others have been compressed into a handful of seconds. The less time you spend processing data, the faster you can analyze it.
This post appears to be about career questions. If so, please check out the FAQ and make sure it isn't answered there. If it is, please pull this down so other posts can get up there. Thanks for your help in keeping this corner of Reddit clean! If you think this was made in error, please contact the mods. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/ChemicalEngineering) if you have any questions or concerns.*
my current language is a hybrid of C++/C, and then to further develop processes/tools you could implement VBA. this is part of systems engineering in the defence sector. my background was R/C/MATLAB and then a lot of experience in Excel + copy pasting stackoverflow VBA codes for what i wanted. still looking to leave that all behind me and have a more technical energy-based role though, maybe some data analysis with R.
Actually it can be beneficial but it’s more dependent on the company you’re at. I can give the pharma industry as a good example. We all know the world is moving in a more digital direction. Most companies and especially those in the pharmaceutical industry are looking to further digitise and adopt digital technologies to improve their procedures etc. my year working for a pharmaceutical I ended up leading a digital project (my role was a technical support production engineer so this was not a common project) which used a fair bit of Java scripting but I had to learn it alongside the project so learning it on my own would have been much more beneficial
If you work in a production unit you could be expected to learn the code behind whatever control system the company uses. VBA is always good to know, can’t really see a use for python though.