From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Automating report distribution with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Automating report distribution with VBA and Copilot
- [Instructor] The final step in completing our report is automating the distribution. Doing this manually can lead to mistakes and stress, so let's automate it to keep things smooth and error free. Just a quick note in this example, one of the automation steps is sending reports out through Outlook email. As you follow along, keep in mind that VBA isn't supported in the new Outlook for Windows. As of now, the workaround is to continue using Classic Outlook, which Microsoft is still maintaining in parallel. Eventually, a longer-term strategy is to move toward Office Scripts paired with Power Automate for Outlook automation. We'll cover Office Scripts more in a later video, so keep this limitation in mind as we continue. We'll start with the workbook report-distribution, which already has the modules for formatting and analysis. Now we'll add a new module for distribution tasks. Whether you're coding yourself or relying…
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.
Contents
-
-
-
-
(Locked)
Automating report formatting with VBA and Copilot3m 59s
-
(Locked)
Automating PivotTables and charts with VBA and Copilot6m 25s
-
(Locked)
Automating report distribution with VBA and Copilot5m 26s
-
(Locked)
Challenge: Automate reports with VBA and Copilot1m 15s
-
(Locked)
Solution: Build polished report macros with VBA and Copilot5m 35s
-
(Locked)
-
-
-
-