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

Video Description

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the code ★ https://exceloffthegrid.com/reusable-office-scripts/ ★ 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 ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel