‍ How to use Office Scripts in Excel & Power Automate

Kevin, you are awesome!

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

i cant see automate option

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

but how to activate automate script feature?

I have office 365 and excel online, but no automate tab

how you differentiate power query to do the same thing instead using script?

I am looking to run a script to do something very simple whereby every week I need to increase the range of a formula by 1 cell from another sheet within the excel file so that it can compare previous year month to date against current year month to date, but I don't want to have to go through every formula for YTD, QTD, MTD and MAT and do this manually, but I really can't work out how I would run a script to do this. Can anyone help?

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

Very nice intro video about Office Scripts!

I have a problem i dont have the automate tab

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 !

Script to remove latest date duplicate(only latest duplicate)

script to add space in before each capital word?

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

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

Hi Kevin, wonder if you could help. I'm struggling to get a script to run in PowerAutomate (or even in Excel) to update a PowerQuery data conection. Just wondering if you have any pointers or have seen this problem yourself. I'm using all online power products. The excel file that I am trying to update is located on SharePoint. This is the script that gets recorded. Works if I am in the workbook, record and then run the script, but if I close all and reopen the workbookthe script no longer works and does not work if used in power automate ......

function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}

I wonder where the hell is the "Automate" tab in Excel to get start with...

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?

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

Hm, we can ask any other topic... Where's Cleopatra's tomb? Who killed JFK? :) Just kidding ... :)

Is it free?

Hi Kevin. I have a scenario where the ops team has used macros in a excel file that resides in a sharepoint location. I need to use flow to automatically run couple of those macros (they used macros not office scripts).

In this case can you guide me on how to have power automate call macro instead of a office script?

Thanks!

'Record action' option not available in my excel automate group. Any help

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.

Hello everyone,

Please i have a question about VBA vs Sheets scripts for 365 office.

In company we use both and i‘ve been learning vba for 1 year. I have excel macros on my workbook and this workbook is shared through 2 departments which can work at the same time, but there is some problems with saved worbooks through departments..

i heard about 365 office which can work with other people, but i need some protected cells, automaticaly fill some cells and other and other.

What is it better for use it if i want to use my workbook in realtime with others? And can scripts the same as macro or are scripts better?

And sorry for my english, Greetings from Czech! 😊

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?

there is no an app call automate

In my Excel for Web automate tab doesn't appear. Is it possible to show it? How?

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!

I'm trying to figure out a script to hide columns based on the date. I know it would be easy to do with a macro, but I'm at a bit of a loss on scripts and haven't found a lot of good resources for it yet. Anyone that could help would be much appreciated. Thanks!

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.

Hi Kevin . Please share the excel file too .

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.

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

Is it possible to convert pdf to tiff using power automate desktop

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

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

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.

Hi! Is there anything like this for Google sheets?

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?

Thanks!

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

I got distracted, cookiessss <3

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.

Great great video

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