From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Refactoring VBA macros to Office Scripts with Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Refactoring VBA macros to Office Scripts with Copilot
- [Instructor] The Copilot skills you've learned so far are key to streamlining the creation, editing, and management of the extensive existing VBA macros. But I also want to introduce another powerful new tool called Office Scripts that is gaining prominence, offering key advantages like cloud-based storage and seamless integration across Microsoft 365 applications. Office Scripts is currently available on preview for Personal and Family Microsoft 365 subscriptions. The full availability may vary. If you're keen to dive deeper into Office Scripts, I recommend checking out my introductory LinkedIn learning course on the subject. For now, let's focus on converting a working VBA macro into Office Scripts. Then enhancing it by automating its execution through Power Automate. This approach ensures reliable cloud-based automation, freeing you from desktop limitations. Let's get started. Open the exercise file, refactor-macros.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.