Do You Need to SWITCH from Excel VBA Macros to Office Scripts?

Рет қаралды 374,252

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Dive into the world of Excel automation with our comprehensive comparison between Office Scripts and VBA Macros. Whether you're a seasoned programmer or a business user, this video is your gateway to efficient task automation in Excel.
🎓 Get access to the complete Excel VBA Course here 👉 www.xelplus.com/course/excel-...
✨ Key Highlights:
▪️ Office Scripts vs VBA: Understand the fundamental differences and their applications.
▪️ VBA in Action: Explore practical VBA examples for dynamic chart creation and complex data manipulation.
▪️ Office Scripts Tutorial: Navigate through Office Scripts with live examples, including recording actions and scripting in TypeScript.
▪️ Advanced Automation: Learn how to integrate Office Scripts with Power Automate for seamless Excel automation.
Office Scripts and VBA macros have a lot in common. They both allow users to automate solutions in Excel. The fundamental difference is that VBA macros are developed for desktop solutions and Office Scripts are designed for secure, cloud-based solutions. At the moment, Office Scripts are only supported in Excel on the web (and in Excel for Teams). The great thing about Office Scripts is that you can use Power Automate to run the script. So you can run your macro without even opening Excel.
00:00 Office Scripts Vs VBA Macros?
00:38 Differences Between VBA and Office Scripts
01:15 How to Use Excel VBA
04:26 How to Use Office Scripts
11:24 Trigger Office Scripts with Power Automate
11:52 Will Office Scripts Replace VBA Macros?
12:27 Wrap Up
LINKS to related videos:
► Introduction to Office Scripts: • Introduction to Office...
► Learn Macros in 10 Minutes: • How to Create & Use Ex...
Complete blog post: www.xelplus.com/excel-vba-vs-...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #ExcelVBA #officescript

Пікірлер: 441

@LeilaGharani 4 ай бұрын

Stay Ahead with Our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

@Dragoninja 3 жыл бұрын

OMG, I'm still trying to understand VBA, now I have to learn Office Script. I'm Overwhelmed. LOL

@LeilaGharani 3 жыл бұрын

Haha, plenty of time for that 😁

@businessintelligencedigita8117 3 жыл бұрын

Learning VBA. Gives u programing logics...Which can be applied anywhere....

@stingehte 3 жыл бұрын

@@LeilaGharani Is VBA from the depth perspectiven not necessarily capability better than many languages? Or under same command other languages are deeper and more dynamic? May be I couldn't frame my question better

@f_alves 3 жыл бұрын

Actually, you got a chance to learn JavaScript. Take 2 buy 1.

@woljin 3 жыл бұрын

Hehe welcome to the club sir. Data and programs are ever changing. We have to adapt. It's always fun to learn new stuff so don't get discouraged. Keep learning VBA but maybe branch out and learn java too. If you're looking at this your probably trying to learn mcode language and dax formulas too. Overall, they are all programming languages. You're learning multiple languages. They are all similar but work a little different. If you learn one, you can learn the next rather easy. Just take this one step at a time. There are many programming languages the world. Excel will not use all of them. If you want to work in office, just focus on the languages it uses and it will make your training tree smaller.

@MiguelCastro-ze2rs 3 жыл бұрын

The best of JS and Excel together. This is really amazing! especially the fact of using a high-demand language like JS, the syntax is easier to understand than VBA and requires fewer lines of code. I'm excited to see your upcoming videos about this. Thanks for sharing, Leila!

@ninobrn00 3 жыл бұрын

Leila, your proficiency astounds me! I don’t know how you manage to always be on top of these things! Simply incredible.

@LeilaGharani 3 жыл бұрын

Thank you! 😊

@henrywycislo9454 Жыл бұрын

I hope Leila is making billions with these videos on youtube. She has an excellent pace with her instructions. Very clear and concise. Thank you for all the M$ videos.

@teoxengineer 3 жыл бұрын

I have started yet learning VBA thanks to Leila VBA courses and I am improving my VBA language every day to automate my excel solution in a short way. I think the step of learning VBA is so late and but so important milestone for me now because the revolution of VBA will turn into DAX language which has been used by PQ and PPivot and other applications. if anybody is familiar with VBA code, learning Script and other DAX codes will be so easy but the main rules will take a bit long time and be doing more practice. Thank you for giving us this new information about VBA's future and revolution Leila, 🧨

@Maya-sv1pz 3 жыл бұрын

will definitely explore Office Script. Thanks for always keeping us updated with the latest and greatest!

@ExcelForFreelancers 3 жыл бұрын

Great video Leila. I like the possibilities of scripts, however it still seems like Microsoft has a long way to go. Events would be a great addition when they get to it. Thanks so much for the creating this. Very well done :)

@antoniogarrido3058 3 жыл бұрын

Automation options is always an interesting topic.. Thanks for sharing Leila!!

@jonkirk2118 2 жыл бұрын

Thanks Leila. I just came across and subscribed to your channel and am really enjoying the videos. Your pacing and presentation are excellent. I've been coding VBA, ADO, Automation between Office and non-Office software (e.g. controlling MapBasic and SPSS Syntax from VBA) plus web development for >15 years and the most important thing I've learnt is that you never stop learning. Greetings from the UK.

@LeilaGharani 2 жыл бұрын

Thanks for watching, Jon!

@AdamGaffney96 3 жыл бұрын

Over the last year or so I had to learn VBA for a massive work project I ran, and while it's good, I found a lot of annoyances with it that you don't get with other languages. Excited to see that the software is going in more of a JS direction, as that's a language I'm already familiar with, and several times throughout my project have written in JS first, before figuring out how that translates to VBA. Great video and excited to see what the future holds!

@vijayarjunwadkar 3 жыл бұрын

Thank you Leila for this nice intro to Office Script! I was relieved to know that VBA is going to sustain for at least a decade as I am undergoing your VBA course on Udemy! 😁 But yes, Office Script is definitely going to be a game changer soon and I am eagrly awaiting your future videos on it! 😊👍

@LeilaGharani 3 жыл бұрын

Thanks for reminding me. I forgot to check the progress you made in the course last week 😎

@ankitmanek456 3 жыл бұрын

Leila, if Oscars were given in the fields of Excel, you would have got hundreds of them for sure! You are one of the best excel faculties on the Planet.

@jamessawyer8565 3 жыл бұрын

I really hope Office Scripts will reach a point of maturity to equal or even exceed VBA pretty fast. Not having to rely on your machine to run the code is brilliant

@stephanweaver1960 3 жыл бұрын

Thanks for jumping into the system directly doing some coding, most efficient way to get going and excited

@swittocx 3 жыл бұрын

I'm happy to hear that Office Scripts is also based on JavaScript, just like Apps Script for Google Sheets. Makes it easier to program automations in both systems. Thanks Leila for sharing!

@alexandercoss 2 жыл бұрын

Totally amazed about the road path Microsoft is taking. Now with most of the products being migrated to the cloud, it is expected to see more tools to help users get the most out of it. Anyway, it will be a while until I grab on to all this. In the meantime, let's continue learning. Thanks Leila, you make it looks so easy!

@szisziszilvi 3 жыл бұрын

A complete new world is opening with all the new office products, and I like it that the products will be connected. It seems to me that MS has a vision now. I am happy that I follow You, Leila, I've started with Excel, but I've discovered so much already with the help of your channel. Hey, don't make me an MS fan, please! I started decades ago a real sceptic, and that was a nice word to it. :)

@LeilaGharani 3 жыл бұрын

Ok, challenge accepted 😁

@retroclasica 3 жыл бұрын

After beginning in the computer world with Open Access II and dBaseIII+, I learned VBA (mainly for MS Access) and its logic and structure helped me understand and use other languages, from php to Python, to mention two I use quite often. But VBA has enhanced and broadened my office’s solutions for almost the last 30 years and I hope it doesn’t disappear but in the end improves and shares more usability with the scripts. I love coding and learning something new every day.

@ashokwwf 2 жыл бұрын

VBA is my first love.

@andrevanopstal2143 2 жыл бұрын

@@ashokwwf For me my second love. My wife was the first.

@ashokwwf 2 жыл бұрын

@@andrevanopstal2143 Lucky you. 👍

@georgetosounidis5545 Жыл бұрын

Holy shit dude! dBaseIII+ ..... what did you just remind me of.... hey, did you use Volkswriter as well ? Remember Norton Tools? THAT was a huge upgrade! We were using EDLIN as a text editor be4...

@Dan_Therapist Жыл бұрын

VBA earned me a 70% pay rise.

@frederic_millenial 3 жыл бұрын

I’m hyped. I’m looking forward to use TS/JS instead of VBA in Excel Desktop.

@finance_with_Naveen 3 жыл бұрын

Great video and want to learn along with you .It would be great in future. I love the way to escalate complex things in a simpler way.

@raulbustamante3748 Жыл бұрын

Is use both! Everything has changed ever since! Increased my productivity exponentially

@DraRed73 2 жыл бұрын

That was well worth watching. Thanks. The limitations of scripts make it dead to me but it is good to know where it is at.

@thomasreinemann4391 3 жыл бұрын

What I think About it? I just started your VBA course last Monday and really excited about it. So I think, can't wait to get your full office scripts course one day ;). Thank you leila. It's just amazing to learn from you :).

@LeilaGharani 3 жыл бұрын

Hope you enjoy it, Thomas!

@vasukollur Жыл бұрын

Thank you for the video, it helped to understand what is the path moving forward for excel in cloud

@robertakwasiadjei8223 3 жыл бұрын

You are amazing Leila. Stay Blessed

@dcpowered 2 жыл бұрын

Wow. This is amazing! Please make a video to show power automate, excel and office scripts!!

@bencale3384 3 жыл бұрын

This opens a whole new world of opportunities linking into Power Automate.

@zitomoreno9408 3 жыл бұрын

For me is better to study Python, this language open Infinite options. I love VBA, is the first language that I learnt, with Vba i can open a register cash, connect to AWS, scrapping, connect SAP, create a rich text box, built a solid desktop app, but it has a limited is web and mobile with phyton you don't have this problem and you can manipulate excel with a one library. For last, remember for many tasks in the office routines start in excel table and finished in a excel table.

@sadvrt 8 ай бұрын

I've just bought your VBA course and now I've spotted you in the wild, even though I've never seen you before the course.

@christosagapiou5611 3 жыл бұрын

Hi Leyla, many thanks for yet one more very informative video! I tend to agree with you that VBA has still a long way to go before it can be fully replaced with Office Script, but I am anxiously looking forward to your next videos on this new thing as well as probably a full course on it!

@LeilaGharani 3 жыл бұрын

More to come! But first I actually have to learn it better 😊

@christosagapiou5611 3 жыл бұрын

@@LeilaGharani As a loyal follower of yours, having studied most of your courses, I am 100% sure of the excellent quality of your work when it will be ready! Keep up the magnificent work!!!

@PhilHibbs 3 жыл бұрын

I didn’t know this existed, interesting stuff! I’ve done a ton of VBA, and recently done quite a bit of Google Sheets scripting which is also JavaScript based.

@amiyaanurag01 2 жыл бұрын

U made my day.....learning another bucket to my cv.

@wulp1191 3 жыл бұрын

I love VBA and I have been using it since the beginning, I started with WP 5.1 macros, Word Basic and Excel macros... At my age, the need to move to scripts is a no go...

@jumpofjoy8815 3 жыл бұрын

I love how everything new and useful is being locked behind business or professional accounts.

@Flatunello 3 жыл бұрын

I assume that comment was facetious.

@siloton 3 жыл бұрын

@@Flatunello I assume, that besides dumb options (upvote) or even crippled (downvote) adding a "joke" voting pictogram ( with various customizable filtering on user side) can solve 30% of pointles chat traffic. Not mentioning few more that can solve the rest :)

@AttackOnTyler 3 жыл бұрын

This is a great video, and I think office scripts will be a great feature down the road. However, most companies tend to restrict office scripts. Looks like vba will still be around for some time.

@theresearchlab3020 3 жыл бұрын

Great. Leila your videos are always always helpful. Thanks

@LeilaGharani 3 жыл бұрын

Happy to hear that!

@tormodsolemslupphaug1043 3 жыл бұрын

The integration with Power Automate, as well as more intuitive user interface for Office Scripts, is a game changer for me at least. It feels like the entry level for Office Scripts will probably be a lot lower, which is a very positive change 👍

@nicolasperdrix5617 2 жыл бұрын

I would also mention debugging. Is it possible to set breakpoints? Leila mentioned a console message, that's less convenient. But I agree that the integration with Power Automate is definitely a great feature.

@divyamehta6102 3 жыл бұрын

Thanks for introducing the concept.Well I have just enrolled in your Excel VBA course. Let's see how far I goes

@LeilaGharani 3 жыл бұрын

Great! I hope you'll enjoy the course.

@anandabherath1009 3 жыл бұрын

Excellent comparison of VBA and scripts. Guess you are right about VBA being around for many more years.

@nikotra 3 жыл бұрын

Part of my job is based on developing VBA macros for Excel/Access, and VBA, as you clearly say, will live for many years on, but I think Office script will be a must for new applications 365-based, so I'd better start studying it (but please let me finish your course on dynamic arrays I'm following on Udemy) :)

@frankdavid8117 3 жыл бұрын

Hi Leila, your vids are so amazing!! Can you automate moving data in a certain worksheet to another worksheet in select columns?

@SeamusHarper1234 2 жыл бұрын

7:05 TypeScript is a superset of Javascript, not a subset ;-) Strictly speaking, it is a strict superset of ECMAScript 2015, which in turn is a superset of ECMAScript 5, which closest to what people call "Javascript". There could be a discussion about if it even is a superset, because some JS code will not run in TS, but that is not because the syntax is invalid, but because TS enforces types. I am really looking forward to Office Script being implemented on the Desktop

@masoudpesaran9721 2 жыл бұрын

Excellent presentation, very informative.

@dipakpingale 3 жыл бұрын

I love all your vedios..always new things increase my knowledge..thank for that🙂

@LeilaGharani 3 жыл бұрын

My pleasure 😊

@Milhouse77BS 3 жыл бұрын

As an VBA user since 1994, this makes me want to learn OfficeScript.

@LeilaGharani 3 жыл бұрын

👍

@Saintor1 3 жыл бұрын

As an VBA user since 1994, this makes me want to stick to VBA. ;o) The rumors of its imminent death were exaggerated.

@rocketbluegoose 3 жыл бұрын

Learn Google script for sheets better

@ah0874 3 жыл бұрын

Same here … will be interesting and fun to learn & have some form of automation in 365 - even if very basic to start off with

@bdr200 2 жыл бұрын

Excellent comparison and intro to Office Scripts. I'd be interested to know if Office Scripts contains the equivalent of being to being able to declare references to libraries such as Microsft Scripting Runtime and other Office apps such as Word and PowerPoint. I've used Excel VBA library references to hardware API's that enable data logging and even proximity detection and control of moving Halloween party props. I'm concerned that Microsoft will depreciate and retire VBA before they have provided a near-functionally equivalent alternative, but having developed complex ongoing VBA solutions for many large companies I think they will receive a significant pushback if they do.

@defariase Жыл бұрын

Awesome video. You are an excel Rockstar!!!

@pcrengnr1 2 жыл бұрын

Leila thx for taking the time in producing this video. Ofc scripts looks promising but lacks a lot of VBA functionality. Coders will have to totally recode as JS operates totally differently than VBA. The language structure is totally different. Some things are better some are worse but different. Sometimes new ain't better only different. VBA is Turing complete Ofc scripts are not at this time. IF MS all of sudden dropped VBA how would industry react. It could cause a huge migration away from MS Ofc X never to return. I feel that VBA keeps MS Ofc ahead of the competition when that's gone goodby MS. Industry has a job to do, when that job can no longer be done by a product they are forced to move on. I hope they, MS, keep VBA around as industry needs stable platforms for decades not just a few years. It's analogous to when IBM got behind the PC, the world jumped on because they knew it would last and they could invest as it had a future. Prior to the IBM PC it was computer of the week. Industry can't afford fad software it needs things that last and last that meets their needs.

@Remars808 3 жыл бұрын

by the way, you are approaching one million subs.... dang things have change definitely

@LeilaGharani 3 жыл бұрын

I can't believe it either! Never thought so many people are interested in these "boring" topics 🤓

@MrLuuHai Жыл бұрын

I hope that, Office Script will be used in Excel desktop As soon As possible. It's really useful and easy to approach.

@Officeinstructor 3 жыл бұрын

Thanks Leila for the Introduction to Office Script... Waiting for the next Video (Nabil Mourad)

@homejonny9326 3 жыл бұрын

Nice video! Besides, VBA seems faster and seems to have a really better IDE (VBE, with a lot of tools so to help you manage your -coffee- code.

@taizoondean689 3 жыл бұрын

Thanks for enlightening us about Office script 👍

@LeilaGharani 3 жыл бұрын

My pleasure :)

@azizquazi 3 жыл бұрын

This will be great if we have a comparison table between Power Query (M), VBA and Office Scripts to understand the differences. To me, I need to understand what M cannot do that other do can do. Thanks

@lockhrt999 3 жыл бұрын

I haven't used office script but with my experience with Google App script (which is used in Google Spreadsheets and both are essentially same JavaScript at the core) I will mention some downsides of it: 1. It'll be 100 times slower than VBA if not thousands. As the code is executed on server side. 2. It's not practical to process rows one by one as VBA people do. Because it's even slower. You will have to put whole table in an array. Then process than array and write that array. However, on the plus side, array in JS are much easier to handle. 3. You can forget close integration with the OS as how VBA has it. (when it arrives on desktop) 4. You can forget creating complicated UI with office script. For that you'll have to learn HTML and CSS. 5. For the web version, your script can't run longer than a few minutes otherwise it'll be killed. I have a few VBA projects which handle a large amount of data and they run for a long time. This can't be done with web version of the office script. 6. These are much less ideal for custom functions (at least in the web version). User can have thousands of rows, and keeping custom function on every row will make your sheet slow as snail.

@lockhrt999 3 жыл бұрын

Another important thing, office script is not available for all. Currently it's available only for 'special need' tier customers. If you must use web version then you better use Google spreadsheet as it has tremendous community support like VBA. The only reason I can think of someone using office script is because their company bought Microsoft's business tier office suite and now they are stuck with it.

@YoLo-nz2fo Жыл бұрын

How about office script use in power automate?

@absolut85 2 жыл бұрын

Thanks for the video. I think as soon as the possibilities increase, the javascript will also increase fast

@TiagoFreire 3 жыл бұрын

being able to trigger them from power automate opens up great possibilities. I would like to see it go towards the other end though, and see the Office Scripts be cached for offline use. VBA is difficult to maintain when you try to issue a new version of the code, with bugfixes or new features, but users keep using the old version. With a new code that is stored outside of Excel, you could update that only. But it would need to keep working if internet is dow not only due to outages, but also if the user is in a place without internet, such as a warehouse or remote location.

@ronhon100 3 жыл бұрын

Leila, thank you very much. I am looking forward your next video about Office Scripts. Do you know if Office Scripts can automate MS Access?

@gf1net 3 жыл бұрын

Thanks for this video. I use VBA (and VBS) very extensively and, while it is extremely powerful in many ways, web automation is kind of a challenge. Fortunately, third parties add-ons such as Selenium can help greatly in that respect. Are these kind of features going to be native in office scripts? By the way, I found that VBS is a good way to share macros across multiple Excel workbooks (similar to what you describe in your video for office scripts)

@wayneedmondson1065 3 жыл бұрын

Thanks Leila. Great insights. I hope VBA has many years of life left. Macros are (relatively) fast, easy to learn and powerful. For those who automate at the workbook/worksheet level and don't need to cross platforms, they are awesome. I get the concept of creating a more universal scripting capability. But, I'd argue that only a subset of users really need it. It would be ideal if Microsoft saw the value in both, but we know that is not happening. Let's hope both the usability and the capabilities of Office Scripts mature before talking about abandoning VBA which, as you mentioned, serves many very well now, even in its outdated and somewhat unappreciated (by Microsoft) condition. Thanks for sharing :)) Thumbs up!!

@LeilaGharani 3 жыл бұрын

Thank you for sharing your thoughts. I hope VBA sticks around too.

@chrism9037 3 жыл бұрын

Great comparison of the two options Leila

@LeilaGharani 3 жыл бұрын

Thanks, Chris!

@Mohammad3000100 3 жыл бұрын

As always you are great and full of surprises. I am wondering if are there and addons to apply this script on my desk top version? could you please make a video for that.

@augustosisa 3 жыл бұрын

VBA has more lives than a cat, I had listened to announces of its retirement for near a decade. And currently, it is still very strong. Nevertheless, Typescript looks good and I agree with you that maybe it will replace of the future, but not in a short term.

@SeamusHarper1234 2 жыл бұрын

No one will ever migrate all this legacy VBA code. Thats like ending C++ life.

@pedrocasique7352 2 жыл бұрын

¡Chido carnala! ¡Greit videou!

@SyedMuzammilMahasanShahi 3 жыл бұрын

This is so beautiful. Thanks for the share.

@LeilaGharani 3 жыл бұрын

You are so welcome

@SimpleExcelVBA 3 жыл бұрын

It is really cool move from Microsoft, especially the code editor. It's a pity that they just stopped to "invest" in VBA. But still they will not resign on VBA for a long time, so totally agree with You Leila :) Please more Office Script videos! :)

@LeilaGharani 3 жыл бұрын

More to come :)

@FernandoMoreiraR 2 жыл бұрын

Always always helpful thank you!

@coffe4wolf 3 жыл бұрын

Thanks for video! Wish VBA get web developing possibilities :c

@omkarsarfare4081 2 жыл бұрын

Great this script feature may very useful for many user to use at a time on one workbook Pls make make a video on search , sum at lastrow through this script

@FRANKWHITE1996 3 жыл бұрын

What a great video! Thanks for sharing!

@th3n3wk1dd 3 жыл бұрын

I learn so much from you. Thank you.

@TimSheets 3 жыл бұрын

I feel so lost with these new technologies. Thanks for breaking it down for us!

@LeilaGharani 3 жыл бұрын

My pleasure, Tim!

@ChrisM541 2 жыл бұрын

Thanks for a well made and interesting video. I wonder, are Office Scripts going to replace VBA? - if yes, there appears to be a huge amount of functionality missing.

@LandscapeInMotion 3 жыл бұрын

Nice find! Will Office script run on the excel desktop?

@marktheirl1842 3 жыл бұрын

I took your VBA course and it was GREAT! Maybe a course on Scripts???

@LeilaGharani 3 жыл бұрын

Yes, but first I have to learn it properly myself :)

@marktheirl1842 2 жыл бұрын

@@LeilaGharani It's been a year and I am still wondering if you are going to do a course on Office Scripts

@NewStreamLine 3 жыл бұрын

VBA is our best friend. Web extensions would be greatly appreciated, though.

@HarpsBhalla 3 жыл бұрын

Great Video, what watch are you wearing Leila ?

@JaimeHaddad 3 жыл бұрын

Great video Leila and interesting to see where this is heading to. Do you think Office Script will be the replacement for "M" on the in the near future? Microsoft needs to standarize the tools. Right now we have VBA, "M" and now Office Scripts. For us is a great challenge learning different things that will be worked within Excel. Thank you!

@LeilaGharani 3 жыл бұрын

Thanks Jaime. It's true - we have so many languages now - M / DAX / VBA / Office Scripts / Power FX functions.. M is used in Power BI too - personally I doubt it will be replaced by Office Scripts because it's a different type of language. Office scripts, like VBA can manipulate files, change source data etc, whereas M is purely for querying data.

@stefanschmid3648 2 жыл бұрын

Thanks for the great video. Leila. It's a topic that should get more attention. Both worlds have great business use cases... but it is very hard to combine both worlds. For example, it seems that macro enabled files (xlsm) are not at all supported by automate flows. I REALLY hope, that the events amd "button" issues will be integrated next. Thats when I will switch to scripts :D

@jwf3148 3 жыл бұрын

My extensive collection of VBA scripts is essential to my workflow. Hoping that Office Script will be accessible to Excel workbooks in a way similar to the way that personal.xls is accessible to all open workbooks.

@annel7004 3 жыл бұрын

Great video Leila! Will you do a course on power bi sometime? Everyone at my company are talking about it! Can’t wait to learn from you!

@LeilaGharani 3 жыл бұрын

That's great to hear, Anne! Working on a DAX course next :)

@MrAIProgrammer 3 жыл бұрын

Thanks for the video !

@barrycasey5670 3 жыл бұрын

Thanks great video, would be interested if there are any courses available

@cavyommmehta 2 жыл бұрын

Informative 💯✔️

@EXCELDOERS 3 жыл бұрын

Great explanation. Java is yet the most complex language on earth and its syntax are not friendly while VBA is still yield better readability. Microsoft is still long to go for script to make it common among developer.

@MikeDerUnwissende2 Ай бұрын

Your video is very informative, but a few updates to VBA would be beneficial. VBA has not seen significant changes since 2016. For instance, adding current TTS constructs or more modern form elements to VBA would be helpful. The question remains whether we can expect such updates from Microsoft, especially since they have shifted their focus towards online elements and documents. I personally write many VBA program extensions, and I don't see it becoming obsolete in the next five years. The extensive use and importance of genuine VBA should continue to be recognized. VBA remains the tool of choice for enhancing Office documents, similar to using Unity or C# directly.

@SBFay01 3 жыл бұрын

Love your tutorial videos, but it would be much more helpful to learn at the outset (description or first minute) that Office Scripts is not available if we don't have a Business or Enterprise account.

@servicesangleaccountants9410 Жыл бұрын

Hi Leila,, I came across this tutorial searching for Combo mixes with no repeats and your presentation caught my eye. I am trying to run or create a report in excel that will give me all possible combinations with a list of 10 items each having 3 possible outcomes, how would you generate a list without repeating any combinations?

@mohammadashiq9996 3 жыл бұрын

I like the simplicity of this video

@Grumpy_Granddad 3 жыл бұрын

I love the way you are prevoking thought around this. I am already thinking MicrosoftTeams -- I have a number of financial and accounts groups where I am sharing and updating spreadsheets with the team but have to open them on desktop to initiate changes and actions. Also on a lighter note I have a macro run bingo board - this might also be a candidate for office scripts and may be where I look to learn and practice. Great channel you have here - Love looking forward to Thursday videos - are we going to see more of "Devil" Leila?

@LeilaGharani 3 жыл бұрын

Thanks Geof. It sounds like you can take advantage of Power Automate with scripts. This way you wouldn't have to open the files to run the code. I'm planning some videos around this in the future. "Devil" Leila ran our ideas for the time being. She needs to get inspired.

@lucicd 3 жыл бұрын

Microsoft should work on VBA modernization. It is still very usable language, which could be improved. It would be great if you could make videos on Office JavaScript API and how to make add-ins.

@arnonym7643 3 жыл бұрын

They have a modern VBA replacement called VB.net - but still, there are too many existing macros out there.

@yokowasis 3 жыл бұрын

@@arnonym7643 can you run vb.net on excel ?

@arnonym7643 3 жыл бұрын

@@yokowasis Not yet. You can run vb.net and access Excel from there, pretty close. But the main point war: they don't have to work on VBA modernization, they just have to integrate vb.net.

@bayurukmanajati1224 2 жыл бұрын

@@arnonym7643 Agree. If they did, then Office will be great and 'uh' something like another VS.

@ArunRajTutorials 3 жыл бұрын

A great intro to office scripts. Those who already know TypeScript / JavaScript will be grinning from ear to ear. Like me 😜

@LeilaGharani 3 жыл бұрын

Talking about a head start 😁

@ahmadbahauddin2194 3 жыл бұрын

Vba is powerful, 10x my salary boommm because of having this vba skill. Like charm!

@JoshuaRosaaen 2 жыл бұрын

Looking forward to Scripts!!!

@pk2k2 2 жыл бұрын

Well Excel runs since the 90's. Surely in the future will solve the Problem Excel - Scripts

@jacquesurlus5943 3 жыл бұрын

We have to see what Office Scripts will bring us. When I started to learn VSTO (Visual Studio Tools for Office) I stopped with VBA. With VSTO I have complete access to the .NET Framework. I write SOAP services, digital signing functions, creation of encrypted databases which are only stored in memory, creation of extendable classes etc. etc. and most important, I have full access to all Office objects. With VSTO everyting is possible in Office, The only limit is your fantasy.

@Chris_87BC Жыл бұрын

Great video! in VBA what is the code snippet that will give you the first value of a cell in a filtered sheet? If the filtered sheet has more than 2 rows of data, my code snippet captures the first value but if the filtered sheet has only one row, it goes and captures the cell value of the next filtered value. (I use a column to filter for all the values in it). :)

@ahmednuru7698 Жыл бұрын

Thank you!

@melissabeasley2884 3 жыл бұрын

Great intro to this! I wonder if vba can call the script….I do love to assign a macro to an object. I wonder…Can scripts send email/share to teams/save visuals as pdf? Can’t wait to start playing with this and for your next vid!

@davidcarrico3385 3 жыл бұрын

Not sure about officescript(as I don’t know it), but the the fact that it opens it up to PowerAutomate means that yes, you can email/share to Teams. PowerAutomate, with the right connector, also allows you to save to PDF.

@gabrielmoreira7265 3 жыл бұрын

I'm super pumped. JS is much better

@linkndark 3 жыл бұрын

My take on this? No need to switch yet, if you know VBA already well. If you don‘t, then start learning OfficeScript/JavaScript. It would enable you to enter entirely different career paths at a later stage. VBA on the other hand is very niche.