•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it worth learning VBA in 2026, or should I shift to Office Scripts? (Confused about my workplace dynamic)
Hey everyone,
I'm currently facing a bit of a dilemma regarding what to learn next to automate my Excel workflows, and I could really use some advice based on my workplace situation.
My Situation:
- My Team: We mostly use standard Excel with formulas. The team is very comfortable with formula-based sheets and prefers keeping things simple.
- My General Manager (GM): On the other hand, my GM heavily uses VBA for macros and automation.
Given that it's 2026, I know Microsoft is pushing Office Scripts (TypeScript) for cloud/web compatibility, but my immediate boss (GM) is still all about VBA.
Should I spend time mastering VBA just to align with my GM, or should I invest my time in Office Scripts/Power Query since they are more future-proof? What would be the smartest move here?
Thanks in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Do you use VBA regularly or have you moved entirely to Power Query and formulas?I have been using Excel for years and VBA was always my go to for automation. Lately I have been seeing more people say they barely touch VBA anymore because Power Query and dynamic arrays cover most of what they need. I still use VBA for things like automating reports across multiple files or generating custom email bodies from data. But I am wondering if I am behind the curve. For those of you who work in data heavy roles, what is your current workflow? Do you still use VBA regularly or have you replaced it with other tools? Curious if I should be spending more time learning Power Query and the newer formula features instead of maintaining my VBA skills. submitted by /u/ProfessionalOk4935 [link] [comments]
- Converting VBA scripts to Office scripts for easier automationhey everyone, currently i have a VBA script that i manually run everytime a certain file is sent from a particular email address. for context the flow of the automation is done this way: file received through email -> automatic download -> manually trigger the VBA automation -> data from the sent file is transformed and kept in multiple different excel files. the automation itself is slightly lengthy and complicated. It basically converts bunch of data from the file sent, breaks it into different files with the required pieces of data for upload. what im trying to look at is, is there any way to basically eliminate this need to manually tiggering this vba automation myself? i get this report sent multiple times a month and as convenient, my vba automation has made this process its still a hassle 😂. I've heard of Office scripts being an option but can anyone please let me know if its possible? any resources would also be beneficial. thank you. submitted by /u/unlucky_ko [link] [comments]
- how did you improve your workplace's legacy vba macros?I recently transitioned to a non-clinical role in a public health care system. part of the on-boarding was a 12 page, 20 step tutorial on how to 'do the macros'. The workflow simplified is: - Get source data from EHR/BI - Open the excel online (microsoft 365) "Daily Review" workbook in the desktop ms excel. (hopes and prayers it doesn't crash) - copy data (columns of patient ID, demographics, medications... you get the idea) from EHR, paste into this Daily Review - run macro (click a button) which cleans, filters, applies conditional formatting i think - save - go back to excel online and resume editing there. The VBA code was created (not sure if it was written coz it has no documentation) by a colleague who is on extended mat leave. I can see a lot of 'modules'. Can't tell which is active. There are probably lots of historical decisions. The daily review file with its many many sheets is saved in multiple locations in case newcomers like me or others break it by accident. I am told we can't change anything like move a column closer to the beginning coz well we can't. I don't know VBA but could probably figure it out if I watch a tutorial on it. I am linux user and know basics of C, python and make good use of my claude code with the pro subscription but never really worked with spreadsheets. I am wondering if anyone was in a similar situation and how you managed it. Is moving to office scripts (typescript) a viable alternative? Any other life improving tips would be appreciate it. Or maybe I should just give up and focus the energy elsewhere? submitted by /u/Neat-Badger-5939 [link] [comments]
- Is excel still worth learning as a skill in 2026?So I'm an upcoming IT student and I've been wondering if it's still relevant to learn excel and other Microsoft software in 2026. Also I thought learning it will really help in the long run, like getting a job and other stuff. My only problem is that: With only basic knowledge about excel, what stuff should I be learning that will benefit me in the long run? (I heard they were formulas like automated computing and other higher level stuff). Will excel EVER be replaced? (Like are there other spreadsheet software that can possibly outperform excel?) How long does it take to know the basic foundation of using excel, and how long does it take to fully able to utilize it professionally? Some questions might be dumb but I really want to have some practical skills that can help me in the future, plus I also wanna try excel pixel art, they look so cool. submitted by /u/Swimming_Tower_5928 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#cloud-based spreadsheet applications#financial modeling with spreadsheets#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#real-time data collaboration#automation in spreadsheet workflows#real-time collaboration#rows.com#AI formula generation techniques#google sheets#cloud-native spreadsheets#generative AI automation#formula generator#workflow automation#cognitive automation#machine learning in spreadsheet applications