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

Показать описание

★ Want to automate Excel? Check out our training academy ★

★ Get the code ★

★ About this video ★
Recently, Office Scripts gained the ability to run scripts using parameters. This means we can provide custom values to change the outcome of the Office Script.

This suddenly makes Office Scripts significantly more useful in Excel.

In this video, we work step-by-step, showing how to change a recorded code into a reusable script that leverages this new feature.

0:00 Introduction
0:30 Outline example
0:55 Recording the action
3:27 Handling errors
6:13 Apply to all
8:22 Apply to all
7:44 Prevent drag and drop
10:44 Sharing scripts
11:35 Quick access
13:24 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

Excel Off The Grid

Рекомендации по теме

Комментарии

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

danschroeder

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

IvanCortinas_ES

Hi Mark.
I think this is awesome. In my daily job, I do some steps where I need to update some queries every day. For example, If I take your course, can I run the script with Power Query?, I mean I learn something like that.
Thanks

gonzuic

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<wsArr.Length; i + + {
I would have expected this to say
for (let i = 0; i<wsArr.Length; i + 1 {
which is the way a lot of iterators work. Do you know why the syntax is different to this?
Thanks once again for all your great content

petercompton

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

ziggle

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.

donniemcgee

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

lotlaxbbc

Great video! I was wondering if there is a way to automate file conversion, say .xls to .csv using office scripts? would really appreciate the help! TIA

ramilaquino

Is there an option for dynamic print area?

mecorowa

If you don't share the scripts, does any one can see the script button added and run it? Thanks.

zhimabukaimen

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

patrickschardt

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 ???

donniemcgee