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.
@@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
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.
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.
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.
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...
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
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, 🧨
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!
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. :)
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 :)
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.
IME with VBA in Excel I've mostly used it to write custom engineering functions rather than to automation subroutines/scripts. I like to make a as much use of Excel's functions as possible mainly because Excel has so many useful function. I wouldn't say I'm an expert with VBA but it's abilities as a procedural/functional language are extremely useful for the kind of functions I've typically written. I'll have to look into Power automate to see if it is similarly useful.
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!
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.
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.
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.
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.
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...
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
@@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 :)
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 :).
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 👍
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.
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) :)
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!
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!
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!!
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! 😊👍
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! :)
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.
So I am very good in VBA but since it seems like everything is going to online now I decided to start looking at the office scripts and even google sheets. the question I have is there a function/method or class in office script to do a pop message box?
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.
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.
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.
@@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.
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.
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
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 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!!!
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.
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.
VBA will be around longer than 10 years because I began using it recently and it's very good in automating anything in Excel or other office programs.. :)
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.
when i learnt VBA, knowing the object structure helped me a lot in navigating through the office objects and manipulating in VBA. How does it relate in JS? I think it might not be easy to correlate office statements from vba to js. I might have to take up JS from scratch for being good at office scripts.
I took your course on Exelplus and I sometime still struggle with VBA as I have a degree in Microbiology and have no computer background whatsoever. So now, what you are saying is that I have so start all over again and learn a new language? Well I guess that's just how Microsoft operate. Instead of making their previous product better and easy to use, they just introduce a new complicated one.
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.
SO the better question, are as students/fans expect a new course from Leila... Office Scripts soon? as a Excel VBA programmer, I will love to have this class. I have always run into issues using VBA while every software in the company differs from versions of Windows and not to mention accurate presentations of data. I don't know why, but Im pretty pumped if there are any Gharani's future Office Scripts classes in the future.
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.
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.
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!
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.
I'm finding that coloborating is generally much smoother using web apps, but the functionality is not there so you have to keep popping into the desktop app to make changes including those for VBA, and this can be clunky and frustrating, so I can see scripts becomming poular for quick short macros. One major issue for mainstream takeup though will be SPEED I woud pay for some of my VBA programs crunching thousands of lines to run faster.
I have been using VBA since it came on the scene after VB 6.0 was shelved. This scripting code appears to be pseudo VBA. I would really like to see how heavily it can be coded.
Hi Ms Leyla, I don't think that yet OS (office scripts ) is a full replacement for VBA, to achieve the same level of functionality on a very complex VBA project you will still have to keep it in VBA, OS is a relatively new automation tool for Microsoft Excel that is designed to work with Microsoft's cloud-based Office 365 platform. While it shares some similarities with VBA, there are some differences in terms of functionality and design. To fully replace you have to use a lot of other tools, Java Scripts, HTML, some APIs, so far it looks too convoluted for me, as the world still relies on strong desktop applications , for example it does not have built-in functions for message boxes or input boxes, but you can create your own custom dialog boxes using HTML, CSS, and JavaScript. Microsoft provides a sample dialog box implementation that you can use as a starting point for your own custom dialogs. Neither does not support worksheet events, but you can use the Office Scripts API to trigger scripts based on changes to a worksheet or range of cells. For example, you can set up a script to run automatically when a certain cell is updated. Neither does not currently support user forms, but you can use custom dialog boxes as a replacement. However, you can't design these custom dialog boxes directly in Office Scripts. Instead, you need to use an external tool like Visual Studio Code or a web-based code editor to design and create the HTML, CSS, and JavaScript code for the dialog boxes. In general, Office Scripts is a powerful tool for automating tasks in Excel, but it may not be a complete replacement for VBA in all situations. If you have a complex Excel application with many user forms or complex worksheet events, you may still need to use VBA to achieve your desired functionality. However, for simpler tasks, Office Scripts can be a good alternative to VBA, but only if you are already using Office 365. For the time being I' will wait until it is really 'cooked' , and the world is ready for it, seems like a challenge for the MS gurus to bring up online all the good-reliable-Excel desktop framework. Regenerate response
As a non IT person, my head is spinning after watching the video. It took me a while to learn VBA, though I am no where near advance , just enough to get my work done.
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
Once in the 80's, in the age of wordstar, lotus123, and the new weird magic Cubecalc (real 3D sheets, you selected view direction and layer), and seeing the limited macro languages available, I thought "What if you could program your word processor....?" And then in the next decade, along came VBA, allegedly starting with Outlook. VBA allows you to grasp the Office program's object model so you can remote control formatting of text and make reports in Word. Not just reports in A Proprietary Report File Format, but real Word reports. I use those object models in Word and Excel extensively. From Delphi and now C#. Even from Powershell! They are partly undocumented, behaviour changed with Office versions, sometimes I have to make my own tweaks such as moving a line before and after printing bc in Print Preview a print margin unexpectedly swells. We maybe don't need the Basic language. But we sure need to access those object models so we can continue make our Time Saving Pixel Perfect Office Magic...
Dear Ms. Gharani: Thanks for asking for comments. I think VS is another step forward in the creation and deployment of AI, which I support. Humanity MUST be removed from drudgery. Although your discipline is fascinating to me, I really do not understand it without devoting myself to it. However, I will still keep you on my subscription list. Most respectfully, NHG
The funny thing is, I have a semi-automated thing that requires my R script to depend on an email parser to 'poop out' text files of invoices and the script produces an excel spreadsheet. But now, because of your video... can I fully automate this process by having excel files and emails in my inbox 'talk to each other' via VB scripts.
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?
Hello! Leila, what are your thoughts? 1. Is it still worth to invest time in learning VBA, when we have tools like PowerQuery (M language) and Power Pivot (with DAX)? 2. What about Python with PyXL extension? Thank you in advance for answers!
Power query is much easier to learn than vba, I think both of them are important , power query is for easier cleaning of data (u can do with vba but more complex codes whereas power query just few clicks sometimes)
Stay Ahead with Our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
Leila, your proficiency astounds me! I don’t know how you manage to always be on top of these things! Simply incredible.
Thank you! 😊
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.
OMG, I'm still trying to understand VBA, now I have to learn Office Script. I'm Overwhelmed. LOL
Haha, plenty of time for that 😁
Learning VBA. Gives u programing logics...Which can be applied anywhere....
@@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
Actually, you got a chance to learn JavaScript. Take 2 buy 1.
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.
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.
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.
VBA is my first love.
@@ashokwwf For me my second love. My wife was the first.
@@andrevanopstal2143 Lucky you. 👍
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...
VBA earned me a 70% pay rise.
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
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, 🧨
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!
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. :)
Ok, challenge accepted 😁
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 :)
This opens a whole new world of opportunities linking into Power Automate.
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.
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.
As an VBA user since 1994, this makes me want to learn OfficeScript.
👍
As an VBA user since 1994, this makes me want to stick to VBA. ;o) The rumors of its imminent death were exaggerated.
Learn Google script for sheets better
Same here … will be interesting and fun to learn & have some form of automation in 365 - even if very basic to start off with
IME with VBA in Excel I've mostly used it to write custom engineering functions rather than to automation subroutines/scripts. I like to make a as much use of Excel's functions as possible mainly because Excel has so many useful function. I wouldn't say I'm an expert with VBA but it's abilities as a procedural/functional language are extremely useful for the kind of functions I've typically written. I'll have to look into Power automate to see if it is similarly useful.
by the way, you are approaching one million subs.... dang things have change definitely
I can't believe it either! Never thought so many people are interested in these "boring" topics 🤓
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!
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.
will definitely explore Office Script. Thanks for always keeping us updated with the latest and greatest!
Thanks Leila for the Introduction to Office Script... Waiting for the next Video (Nabil Mourad)
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.
Thanks for watching, Jon!
Automation options is always an interesting topic.. Thanks for sharing Leila!!
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.
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.
How about office script use in power automate?
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...
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
I love how everything new and useful is being locked behind business or professional accounts.
I assume that comment was facetious.
@@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 :)
Is use both! Everything has changed ever since! Increased my productivity exponentially
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 :).
Hope you enjoy it, Thomas!
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 👍
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.
I took your VBA course and it was GREAT! Maybe a course on Scripts???
Yes, but first I have to learn it properly myself :)
@@LeilaGharani It's been a year and I am still wondering if you are going to do a course on Office Scripts
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) :)
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!
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.
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!
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!!
Thank you for sharing your thoughts. I hope VBA sticks around too.
I hope that, Office Script will be used in Excel desktop As soon As possible. It's really useful and easy to approach.
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! 😊👍
Thanks for reminding me. I forgot to check the progress you made in the course last week 😎
Wow. This is amazing! Please make a video to show power automate, excel and office scripts!!
Excellent comparison of VBA and scripts. Guess you are right about VBA being around for many more years.
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! :)
More to come :)
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.
So I am very good in VBA but since it seems like everything is going to online now I decided to start looking at the office scripts and even google sheets. the question I have is there a function/method or class in office script to do a pop message box?
I’m hyped. I’m looking forward to use TS/JS instead of VBA in Excel Desktop.
Thanks for video!
Wish VBA get web developing possibilities :c
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.
No one will ever migrate all this legacy VBA code. Thats like ending C++ life.
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.
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.
They have a modern VBA replacement called VB.net - but still, there are too many existing macros out there.
@@arnonym7643 can you run vb.net on excel ?
@@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.
@@arnonym7643 Agree. If they did, then Office will be great and 'uh' something like another VS.
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.
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
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.
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!
More to come! But first I actually have to learn it better 😊
@@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!!!
Thanks for jumping into the system directly doing some coding, most efficient way to get going and excited
A great intro to office scripts. Those who already know TypeScript / JavaScript will be grinning from ear to ear. Like me 😜
Talking about a head start 😁
Thanks for introducing the concept.Well I have just enrolled in your Excel VBA course. Let's see how far I goes
Great! I hope you'll enjoy the course.
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.
You are amazing Leila. Stay Blessed
Great. Leila your videos are always always helpful. Thanks
Happy to hear that!
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.
VBA will be around longer than 10 years because I began using it recently and it's very good in automating anything in Excel or other office programs.. :)
I hope so, especially since I started using Seleniumbasic for my browser automation.
Nice find! Will Office script run on the excel desktop?
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.
when i learnt VBA, knowing the object structure helped me a lot in navigating through the office objects and manipulating in VBA. How does it relate in JS? I think it might not be easy to correlate office statements from vba to js. I might have to take up JS from scratch for being good at office scripts.
I took your course on Exelplus and I sometime still struggle with VBA as I have a degree in Microbiology and have no computer background whatsoever. So now, what you are saying is that I have so start all over again and learn a new language? Well I guess that's just how Microsoft operate. Instead of making their previous product better and easy to use, they just introduce a new complicated one.
U made my day.....learning another bucket to my cv.
Great comparison of the two options Leila
Thanks, Chris!
VBA is our best friend. Web extensions would be greatly appreciated, though.
Well Excel runs since the 90's. Surely in the future will solve the Problem Excel - Scripts
Excellent presentation, very informative.
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.
¡Chido carnala!
¡Greit videou!
I'm super pumped. JS is much better
SO the better question, are as students/fans expect a new course from Leila... Office Scripts soon? as a Excel VBA programmer, I will love to have this class. I have always run into issues using VBA while every software in the company differs from versions of Windows and not to mention accurate presentations of data. I don't know why, but Im pretty pumped if there are any Gharani's future Office Scripts classes in the future.
That's good to hear 😁 There will be a course but not soon. First, I have to learn it myself :)
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.
Awesome video. You are an excel Rockstar!!!
Looking forward to Scripts!!!
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.
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!
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.
We have to accept changes & 10 years is more than enough time to learn this script language.
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.
I feel so lost with these new technologies. Thanks for breaking it down for us!
My pleasure, Tim!
Thanks for the video.
I think as soon as the possibilities increase, the javascript will also increase fast
Great Video, what watch are you wearing Leila ?
Thank you for the video, it helped to understand what is the path moving forward for excel in cloud
This might be a silly question but where does Power query fit into all this?
My thought exactly. Learning Power Query and combing that with VBA has been a game changer for me. I'd love to see this power in the web
I'm finding that coloborating is generally much smoother using web apps, but the functionality is not there so you have to keep popping into the desktop app to make changes including those for VBA, and this can be clunky and frustrating, so I can see scripts becomming poular for quick short macros. One major issue for mainstream takeup though will be SPEED I woud pay for some of my VBA programs crunching thousands of lines to run faster.
I have been using VBA since it came on the scene after VB 6.0 was shelved.
This scripting code appears to be pseudo VBA. I would really like to see how heavily it can be coded.
Hi Ms Leyla, I don't think that yet OS (office scripts ) is a full replacement for VBA, to achieve the same level of functionality on a very complex VBA project you will still have to keep it in VBA, OS is a relatively new automation tool for Microsoft Excel that is designed to work with Microsoft's cloud-based Office 365 platform. While it shares some similarities with VBA, there are some differences in terms of functionality and design.
To fully replace you have to use a lot of other tools, Java Scripts, HTML, some APIs, so far it looks too convoluted for me, as the world still relies on strong desktop applications , for example it does not have built-in functions for message boxes or input boxes, but you can create your own custom dialog boxes using HTML, CSS, and JavaScript. Microsoft provides a sample dialog box implementation that you can use as a starting point for your own custom dialogs.
Neither does not support worksheet events, but you can use the Office Scripts API to trigger scripts based on changes to a worksheet or range of cells. For example, you can set up a script to run automatically when a certain cell is updated.
Neither does not currently support user forms, but you can use custom dialog boxes as a replacement. However, you can't design these custom dialog boxes directly in Office Scripts. Instead, you need to use an external tool like Visual Studio Code or a web-based code editor to design and create the HTML, CSS, and JavaScript code for the dialog boxes.
In general, Office Scripts is a powerful tool for automating tasks in Excel, but it may not be a complete replacement for VBA in all situations. If you have a complex Excel application with many user forms or complex worksheet events, you may still need to use VBA to achieve your desired functionality. However, for simpler tasks, Office Scripts can be a good alternative to VBA, but only if you are already using Office 365.
For the time being I' will wait until it is really 'cooked' , and the world is ready for it, seems like a challenge for the MS gurus to bring up online all the good-reliable-Excel desktop framework.
Regenerate response
Can Power Automate Desktop be used in conjunction with Excel desktop/VBA?
Can we write custom functions using office script (like what we can do in vba) ?
As a non IT person, my head is spinning after watching the video. It took me a while to learn VBA, though I am no where near advance , just enough to get my work done.
Getting up to speed with Office scripts should be easy for you since you already know some VBA.
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
Once in the 80's, in the age of wordstar, lotus123, and the new weird magic Cubecalc (real 3D sheets, you selected view direction and layer), and seeing the limited macro languages available, I thought "What if you could program your word processor....?"
And then in the next decade, along came VBA, allegedly starting with Outlook.
VBA allows you to grasp the Office program's object model so you can remote control formatting of text and make reports in Word. Not just reports in A Proprietary Report File Format, but real Word reports.
I use those object models in Word and Excel extensively. From Delphi and now C#. Even from Powershell! They are partly undocumented, behaviour changed with Office versions, sometimes I have to make my own tweaks such as moving a line before and after printing bc in Print Preview a print margin unexpectedly swells.
We maybe don't need the Basic language.
But we sure need to access those object models so we can continue make our Time Saving Pixel Perfect Office Magic...
Vba is powerful, 10x my salary boommm because of having this vba skill. Like charm!
Now from this video I know there's such a thing as office script, and also from this video I know that VBA is better.
Dear Ms. Gharani: Thanks for asking for comments. I think VS is another step forward in the creation and deployment of AI, which I support. Humanity MUST be removed from drudgery. Although your discipline is fascinating to me, I really do not understand it without devoting myself to it. However, I will still keep you on my subscription list.
Most respectfully,
NHG
10:13 a more apt term i think is "zero-indexed" instead of "zero-based".
The funny thing is, I have a semi-automated thing that requires my R script to depend on an email parser to 'poop out' text files of invoices and the script produces an excel spreadsheet. But now, because of your video... can I fully automate this process by having excel files and emails in my inbox 'talk to each other' via VB scripts.
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?
Hello!
Leila, what are your thoughts?
1. Is it still worth to invest time in learning VBA, when we have tools like PowerQuery (M language) and Power Pivot (with DAX)?
2. What about Python with PyXL extension?
Thank you in advance for answers!
Power query is much easier to learn than vba, I think both of them are important , power query is for easier cleaning of data (u can do with vba but more complex codes whereas power query just few clicks sometimes)
MEM, how to skip already protect excel workbook and next file protect with password by excel vba
Always always helpful thank you!