How to automate Excel with reusable Office Scripts

No video

How to automate Excel with reusable Office Scripts | Excel Off The Grid

Рет қаралды 11,332

Excel Off The Grid

Күн бұрын

Пікірлер: 39

@ExcelCampus 4 ай бұрын

Great video Mark!

@ExcelOffTheGrid 4 ай бұрын

Thanks Jon 😁

@danschroeder8008 4 ай бұрын

I'm sure the possibilities are endless with input. Great tutorial with lots of extra tips. Thanks so much.

@IvanCortinas_ES 4 ай бұрын

Excellent tutorial, Mark. Excellent that you have told this topic. Thank you for staying up to date with the news.

@ExcelOffTheGrid 4 ай бұрын

Most updates are discoverable - but this would be difficult to find. So glad could help.

@corinnemazaleigue1619 3 ай бұрын

Great Video Mark Proctor

@ExcelOffTheGrid 3 ай бұрын

Thank You 😁

@donniemcgee7523 4 ай бұрын

You have been so helpful with your amazingly well done tutorials. I am grateful for your well-thought out and executed videos. I wanted to send you a few dollars to show a bit of my appreciation. Unfortunately, I cannot see an icon upon which I can click to send a token of my appreciation.

@ExcelOffTheGrid 4 ай бұрын

Hi Donnie - if you like what we do, and you watch the videos then you've already given us the most valuable thing you have... your time. If you like our content, all we ask is that you share it with others. Also, feel free to join our insiders program (it's free). We have ebooks and the example files for you to enjoy. Sign up here: exceloffthegrid.com/insiders-signup/

@rajeshmajumdar4999 4 ай бұрын

Thank You.

@ExcelOffTheGrid 4 ай бұрын

You're welcome 👍

@petercompton538 4 ай бұрын

Hi Mark, I love your videos, both for their content and for your very engaging delivery! Just a question: I'm looking at the screen at 8:28 of the video and you have a line saying for (let i = 0; i

@ExcelOffTheGrid 4 ай бұрын

Hi Peter. Office Scripts is based on JavaScript. There are various was to increment an iterator with JavaScript. i + 1 by itself won't do anything as it doesn't allocate the new value back to i. It would need to be: i = i + 1 But there are other shorthand methods i++ ( iterates by 1 ) i +=1 ( iterates by the number after the = ) I'm not sure about other languages, but that's how JavaScript works.

@noraiBI 4 ай бұрын

Really usefull Mark

@ExcelOffTheGrid 4 ай бұрын

Glad you think so! 😁

@ziggle314 4 ай бұрын

I clearly need to do more office scripts! Thanks for the inspiration.

@ExcelOffTheGrid 4 ай бұрын

It's still early days for Office Scripts. So it's a good time to be the leader of the pack. But the UI and IntelliSense is definitely more enjoyable than the Visual Basic Editor.

@mecorowa5642 3 ай бұрын

Is there an option for dynamic print area?

@lotlaxbbc2787 4 ай бұрын

Thank You. Do you have a reusable script for protection of all the sheets as well?

@ExcelOffTheGrid 4 ай бұрын

Do I have one? Yes. But you could follow the same process as shown in the video and create your own 👍

@patrickschardt7724 4 ай бұрын

Is there a way to get a password input for each sheet as it loops through? I’m new to scripts. I’m glad the syntax and editor window is similar to Power Query Advanced Editor

@ExcelOffTheGrid 4 ай бұрын

You would need to provide all the passwords at the start. As a list or range of cells.

@donniemcgee7523 4 ай бұрын

Can a script be used to clear all slicers? I have a macro that does that, but my workplace blocks all macros (and we are disallowed to unblock them by saving the file, right clicking, select properties and select unblock) Maybe a script can help with that ???

@ivanmamchych5802 4 ай бұрын

Clearing all slicers is the same as clearing all filters. You can find the menu button "Clear Filter" and add it to your Excel Quick Access Toolbar

@ExcelOffTheGrid 4 ай бұрын

I didn't know. So I tried it out. Here you go... function main(workbook: ExcelScript.Workbook){ let sliArr = workbook.getSlicers() for (let i = 0; i < sliArr.length; i++){ sliArr[i].clearFilters() } }

@donniemcgee7523 4 ай бұрын

@ivanmamchych5802 thank you very much. That was extremely helpful. I tried doing that on the data tab (which was my mistake) . It works perfectly from the pivot table analyze tab. Thank you again

@donniemcgee7523 4 ай бұрын

Amazingly gelpful. Thank you so much!@@ExcelOffTheGrid

@MichaelBrown-lw9kz 4 күн бұрын

Is there a book I can purchase on Office Scripts for Excel?

@ExcelOffTheGrid 2 күн бұрын

Not to my knowledge - I’ve got a course if you’re interested: courses.exceloffthegrid.com/office-scripts-course

@ExcelWithChris 4 ай бұрын

Do these work in an Excel file on-line? Because macro's do not run.

@ExcelOffTheGrid 4 ай бұрын

Yes, they work in Excel Online (assuming the correct licence). That's where Office Scripts were originally released.

@nikwak 4 ай бұрын

I can't seem to get the Automate tab to show on ribbon

@ExcelOffTheGrid 4 ай бұрын

Either you don't have Excel 365, or your licence does have Office Scripts included (check our your licence here: learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits?tabs=business)

@PubuduPerera 4 ай бұрын

Contact your admin. Automate need to be enabled by admin account in 365