👩‍💻 How to use Office Scripts in Excel & Power Automate

[@KevinStratvert]

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@ameriknu84]

Since we are working everyday it excel, maybe you can showcase power automate or power automate desktop on how to build flows to copy data from one excel to another, delete row/columns update pivots, save and send via email as attachment. That will be amazing

[@derekcanmexit]

It's amazing what Microsoft can do to help automate one's workflow -- very curious to learn more!

[@gajabathiarjuntg2390]

Great video Kevin. Never heard of this word Office Scripts but you've now explained Office scripts are useful to automate your day-to-day tasks and how it works. Thanks Kevin 😀

[@KevinStratvert]

Great to hear!

[@sohitthakur6660]

Amazing! I was new in Office Scripts and understood in one go Thanks!

[@Simon-vc1wk]

Might be best to convert sample dataset to a table, that way if new rows are added your profit column calculation formulae won't be impacted.

[@maheshkakar2258]

Hi Kevin, your video are very interesting with simple and to the point explanation. Thank you for your video which help us to understand this excel with interest.

[@VonKrause]

This channel is really helpful it should get more attention. I hope you will reach 1 mill some day

[@jameszhou162]

great stuff Kevin! one thing i must say is that you got really good voice to deliver the training. normally i cannot bear any vid over 15 min, but this 25 min, it felt pretty short. if you got any courses available in udemy or elsewhere, please let me know. thanks.

[@davidadams421]

Seems like Office Scripts is the love child of: Macros + Office VBA + Nice User Interface = Office Scripts.

[@adastra79]

I suppose this is a good thing.

[@dougtvedt890]

Great video, Kevin! Thank you very much! As someone that has several repetitive monthly reports to do, I've been seeking a way to automate them for a long time. I've developed a lot of macros to help with automation, but was unfamiliar with Scripts until this video. My question is how to use both macros and scripts to completely automate this process.

[@AmyWharton]

Hi Kevin. This is great!!! I'd love it if you would do videos showcasing more advanced applications of Power Automate and Office Scripts. Thanks so much!

[@itsamazing22]

I never thought you can program in Microsoft office this is just very useful to me

[@anwarkrg9292]

Hi Kevin, thanks for sharing this video. Can you please advise how to look up data in the active worksheet from another worksheet and how to put in the flow.

[@ashokanselliah9571]

Very.much interesting. I will start today itself and it will save tons of time. Many thanks Kevin for your invaluable information in this video

[@anjukaul4477]

Hi Kevin. This was a great introduction to Office scripts. Please suggest if there is a way to run these scripts on desktop files

[@JennTheWriter]

What a great tool! Love it and Power Automate too! Thank you for a great explainer video. :)

[@prokorshopal4865]

0:05 - Hi Kevin! 👋 24:53 - 238th thumbs up from me! 👍 Cheers!

[@wannesbrawl610]

Hey Kevin, I would like to thank you first for all your videos, tutorials and all helpful stuff your are sharing. May i do a request? I m trying to send PDF files to one email address. I would like to use Power Automate or mailmerge. I followed your helpful tutorial (how to send mails with attachment with mailmerge) with succes! Do you have any suggestions how to do this? The title of the mails is the name of the pdf file, there has to be no Body text, maybe just the word archive on the titel as prefex for each mail. Thanks in advance! Keep the good work Greetings Simo

[@genesioz]

Nice basic presentation. I would like to know what I can't do with Office Scripts compared to VBA on the desktop. For example, can I clear filters when a user exits from Excel?

[@mdrahmathussain3224]

Thanks kevin for this video!!. I have a query that can we run macro script using power automate cloud flow only directly or indirectly??

[@chulakapitigala5147]

Thanks a lot Kevin, Can you give a guide to Script Lab as well, It works in desktop versions as well..

[@Interesting-AF]

Hey Kevin, great video. As an insider (I know, not any more), any idea when Microsoft will support Excel Online auto refresh connections?

[@AnwarHussainFaruqh]

it is a great illustration and very enlightening dear @KevinStratvert ! Thank you so much ! I just wanted to know, how we can get data ( text, numbers and some pictures ) from the available pdf documents and create new Word documents as per our conditions ( if, then, Loop) 😊 Could you please suggest a way out ? Appreciate your support !

[@newmandoss]

Yes, it's very useful, its level more than macro, but a lot to learn for using this😁

[@elsym613]

Hi @Kevin! Thank you very much for a great video! I plan to use this at work :-). Can you pls show how can we change a range. For example you bolded the first column A4:A9. If my range changes everyday, how can I say rage A2: A “end”of the row? Thanks a lot and you are the best! Cheers, E.

[@omarel5]

Great video, thank you! I was wondering if it's possible to use the script to refresh Power Query or DAX queries?

[@TiagoFreire]

Office Script is great! The weak spot is the inability of running them if internet is unavailable. If a file is synced to disk, and already has a Script associated with it, it should be possible to run them offline.

[@markfeodoroff7303]

Great video and very easy to follow. ExcelScript seem to have lots of capability working inside a workbook. I need to export/print/save the first worksheet to a PDF. Does ExcelScript's capabilities extend to file handling?

[@classytalks4310]

Similar to macro. Great tip! Can you please do a video on how to create and run a script with Google Sheets?

[@KevinStratvert]

Great suggestion!

[@emilycanada7903]

You looks like my little brother. Love your video, very high quality

[@canirmalchoudhary8173]

Very insight tutorial on Office Script

[@chrisr3674]

Thanks you kevin for this video you are the best youtuber

[@KevinStratvert]

Wow, thanks!

[@nurulnajwasafie2508]

This is fun!!! thanks for the content. Looking forward for more from you :D

[@adelle1441]

i am so hooked watching your vids

[@corochena]

Very nice intro video about Office Scripts!

[@Rizwan1875]

This is exactly what I was looking for... 😍👏

[@Ricocase]

Cool video. Can scripts automatically identify keywords within workbooks before running?

[@maaloufcharbeljoe8910]

Beautiful video, Thank you Kevin Stratvert & You are the best

[@KevinStratvert]

Thanks Maalouf!

[@maaloufcharbeljoe8910]

@@KevinStratvert You are the best

[@jeffkerr7038]

That is pretty cool. Thanks and keep them coming.

[@KevinStratvert]

More to come!

[@gracechurchmiltonontario3902]

Great video and it could help with some of our processes. But our organization has a mix of Business Premium and Business Basic accounts. Only the Business Premium accounts have access to automate in Excel. If a Premium user creates a script for a spreadsheet and shares it with a Basic user with full edit permissions, would the Basic user be able to run the scripts?

[@arguetlam2]

Same question here. Got any info about this already? In my team we all have basic 365 so we are wondering if upgrading just one license to make scripts will allow other users with access to the workbook to run them (for example, making a button that registers data from a userform into a database so that every member in the team can use it). Thanks!

[@PragneshBhalodiya]

Hi Kevin, Could you please create a video on how to set up meta, hashtag and keywords for youtube video ? what should be the maximum numbers for it ? and also need assistance on adding transcript (video section) in it. Lots of love from India..

[@brianzhu9308]

Very useful video! I have some source data in text file that I need to distribute to other teams in excel file using automate on a daily basis. Do you know if there is a way to convert text file to excel using the script? Thanks

[@krishj8011]

awesome tutorial..

[@opjazz]

Great video! Is it possible to use type script in excel for desktop as well? And create scripts online and use on desktop version and vice versa?

[@lisabarsalona7585]

Great video. Thanks. Can office scripts connect to SQL databases to run stored procedures? I have VBA written and need to convert to office script for web based excel users. Thanks in advance.

[@francescocotroneo8203]

Hi Kevin. Very clear introduction. I would like to insert data from an Excel online spreadsheet to a Word online document (I do non use desktop office). Is that possible? In word online I do not see the developer tab and do not know how to activetate it or if it's possible to activate it. Thanks for any suggestion.

[@tonilive7719]

Excellent video thanks!!! Is it possible to make a video of Script Lab, for those who don't have a business or school version of Office 365? Thanks very much!!!

[@KevinStratvert]

Thanks Toni! Great suggestion, I'll add to my list. Cheers!

[@realbeetlejuice]

holy crap, this is brilliant.

[@menschnars]

Another gem! Keep up the good work!

[@KevinStratvert]

Much appreciated!

[@CarylVanessa]

Thank you much Kevin! 🥂

[@JustBlankNoInfo]

Well, there is nothing to say! You rock!

[@KevinStratvert]

Thanks Dark Dudes AI... appreciate all your comments!

[@shishirjakhmola5104]

Nice! Thanks Kevin.

[@KevinStratvert]

Thanks for watching!

[@doyler78]

Thanks for the video. Great info. There's a very annoying problem with office scripts and power automate. Scripts use the ID of the file and not the name of the file, even though you select by name. That means you cannot run the script on new files, even of the same name, as it comes back with workbook not found. I have an email that comes in every day with purchase order information which I need to reformat and email onwards however I cannot automate it as the file that gets created from saving the attachment has a new file id every time it is saved therefore the script fails. You have to open the file and run the script manually so it's utility with Power Automate seems very constrained as files would have to be changed in Excel in order for it treat it as the same file or you have to do as I do and run the script manually. Not so great for automation.

[@revanth_kanteerava]

Hello Kevin can u make a video on automating excel to send an automated email with power automate and scripts , u gave an insight , pleas share that in detail

[@KevinStratvert]

Check out this video: kzbin.info/www/bejne/hJ2YcqKCqtiBiJY

[@argyrodriguez5458]

Great Video. I need to use Power Automate calling an Officescript that would pivot a dynamic table. The Original table created by PowerAutomate has Year-weeks on the rows and sme Student info ( attendance) on the columns. I need to pivot the table, so that the Year-weeks ( changing every year) are columns and the rows are Student plus attendance. I have implemented this scenario using SSIS Packages and also calling a Script but now I am converting the SSIS package to a PowerAutomate flow using cloud data. Do you have a video or an example over how to achieve this? Thanks

[@stlaurent26]

Kevin, you are awesome!

[@RupaliDasp]

Hi Kevin, can I perform the recording on the desktop version, save the file online, and then perform power automation?

[@equinonez55]

Could you do a piece on how to calculate CAGR% on a series of periods for an investment?

[@chaomac]

awesome video Do you know how to use Power Apps? I am just learning and wanting to build an app like a shopping cart click and collect for my canteen

[@KevinStratvert]

Here's my intro to Power Apps: kzbin.info/www/bejne/aIPddJWaar2agMk

[@digigoliath]

Awesome!! TQVM!

[@srimanthn7752]

Great video

[@christophesanchez8654]

Excellent. Thanks

[@suzannecadden9044]

Hi Kevin! I just found your channel and really appreciate your videos. I JUST learned a little about VBA, wrote (copied and tweaked) a couple of macros and I am super proud of the work I have done. Now we decided to use a particular file in Teams so there is one macro I need to convert from VBA to Script. I wrote the script and when I run it, I am not getting any errors but it also doesn't accomplish my goal. I can't record the script because I am trying to enable outlining on a protected sheet which is something I needed to accomplish via macro. Do you know if this can even be done in a script or is it something that can only be done in VBA in the desktop version of excel? Thanks for your thoughts!

[@tridibbiswas3361]

Hi Kevin, Thank you for tutorial. Is it possible to edit the Office Script offline on a code editor like VS Code locally on the desktop and then again upload to the cloud , where the initial one was. Also is it possible to expand the code editor for Office Script on web to cover the entire screen so as to give more screen real estate

[@joshprice936]

Great video! Can Office Scripts or Power Automate work with vlookup from two separate spreadsheets?

[@poqwieu]

Hi Kevin, is there a way to save this into a new workbook with a dynamic name? or to create a new workbook using office scripts? Thanks!

[@ManojKumar-zn2gf]

Great vedio Kevin, I have the files in sharepoint server instead of onedrive. Is it possible to run office scripts for files which is present in sharepoint server using power automate flow? When I for the files present in onedrive it worked but not for files present in sharepoint. I would be better if I got calrity on this. Thanks in advance!

[@WHY-s6l]

HI Kevin， I love your videos, but why I can not see the automate tab in my office 365? neither in desktop or web

[@dorraboughzala7639]

Thank you for sharing this. Please do you know if we can insert multi select drop down list in Excel web? I can't find an answer ou there :/

[@janicemendoza376]

Great tutorial! I am getting an error of 'The file format is not recognized. Please check that the selected workbook is valid. clientRequestId: d2ded74b-3b89-4ebc-a5dc-b3cdde83738e.' The Excel file is .xlsx saved in the correct SP library. When running the script outside of Power Automate, works perfectly well. Thanks!

[@diligentjohn]

Can you also do a video on Script lab

[@KevinStratvert]

Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!

[@diligentjohn]

@@KevinStratvert Thank you very much, We are very happy that the content you post is very nice ... One content which I am looking forward is Bing programmable search and python

[@mitz5398]

hey kevin, can u make a video on filmora X

[@yominiyi263]

Great great video

[@gmcguy]

Thanks!

[@KevinStratvert]

Thanks so much! Much appreciated 🙏

[@Giraffe-j3h]

thanks bro

[@tejassripad1170]

Hi Kevin.. Thank you for the above guide, I want to merge multiple excel files existing in share point document folder to one Master file and each time new file is updated in share point folder Flow need to pick up the latest excel file & copy to my Master file. Can you please help.

[@ry8756]

Here's an idea for a video. Schedule a task at a particular time to run an application. My wife says I snore. I don't believe it. I would like to be able to have the Audio Recorder to start recording at a particular time for a particular duration and store the file so I can play it back and hear if I actually snore.

[@KevinStratvert]

You should check out a Wyze camera. You can set thresholds for sound and it’ll record sound when it goes above the set threshold. They run for about $20.

[@itsamazing22]

Amazing

[@KevinStratvert]

Thank you! Cheers!

[@itsamazing22]

@@KevinStratvert your welcome

[@TechnicalAdarsh14]

Please explain about the "developer" tab in PowerPoint.

[@KevinStratvert]

Thanks for the suggestion! I've added this to my list. Stay tuned. Cheers!

[@SnowRiderFree]

Hi Kevin, Thanks for the useful info...I'm struggling splitting a number in excel using scripts...I would like to split in thousands, hundreds and dozens in the respective cells...ex: 1234 splitted in 1 uK, 2 h, 3da and 4u, showing the result in the relative cells...I tried to use a script in js but don't know why doesn't recognize a variable and script goes in error. Please, any advise? Appreciate the support, Thanks

[@aradhyamudigonda4513]

Can we use Power Automate to export sales funnel charts created in Excel for multiple categories/brands so that they all appear in one slide?

[@erinfield1943]

11:50- he explains the code of his recorded script

[@juliorodriguezp]

I don't see the "Automate" option in my excel, how can I activate it?

[@jinlin3317]

It's available in excel online version, not in desktop app.

[@maradying6119]

Thanks Kevin. How do I get "Automate" to the excel online? I use Microsoft 365 family.

[@dawaisold9268]

Could you do a tutorial about Adobe premiere pro

[@tpeiNNN]

can u make a tutorial on how can i give permision on users who can edit my worksheet per selected cell range like in google sheet you can select and restrict users what cells they can edit and cannot. thanks in advance

[@element74]

what options do ppl have who own the 2021 office version (not 365)? can you use timed script that run weekly or daily?

[@dalskiBo]

Thanks, what version did Excel make Javascript default over VBA? I'm in 2016 & VBA is still default. I know you can reference external libraries in VBA; I'm just asking out of general interest.

[@coldplay5467]

@Kevin S. is there a way to migrate Excel VBA code into Office Scripts?

[@exceldude2001]

Can you create custom functions in office script? if not how would you accomplish that in excel online?

[@Thehavemans]

How does this differ from power query? And when would you use one vs the other? In your example what it the number of rows varied from report to report?

[@KevinStratvert]

Power Query is ideal for formatting data before importing into Excel. With Office Scripts, you can set up logic to do all sorts of things (e.g. when someone fills out a Microsoft Form, enter the data into Excel and then update the worksheet based on the form responses). For variable number of rows, you can select the entire column or alternatively you can set up a loop to go through row by row until it hits an empty row.

[@someone7481]

I'm a writer as a hobby and I also deal with NDAs at work so any documents I create needs to be secure and only o. My laptop. It's all word and excel but Ive recently come to Microsoft from Apple and was frustrated with having to buy office. Ive come to terms with it but I need to know it's secure and private before singing up.

[@shwetamirajkar1306]

Hi Kevin, I have used a run script command in my flow & I have shared the flow with my colleague. But when he runs the flow, it stops at run script & doesn't execute even after all the permissions are given. Any idea what can be the solution?

[@abhishekkamble9895]

By VBA or macros we assign a code or command to a button. How can we do that with using scripts. (I mean if I clicked a shape button then excel should be converted in to PDF and should be saved on onedrive)

[@johnborg5419]

Hi Kevin. I do not have the Automate Tab on my version. Can you give me some ideas please. I am in Office Insider.

[@naveenkumarpenumalla7221]

Hi Kevin, I have a requirement like excell with color based on status when download excell data from gallery items. can we do it like that using power automate? Please let me know if any possible ways. thanks in advance.

[@jacobobinguar1440]

Thank u

[@abhishekkamble9895]

Will this excel work on Android OS devices..?

[@curlingjeff]

Is it possible to automate between MS apps. Like copy text from Excel then paste into Word?