Learn how to create automated reports using VBA, save them to a network directory, convert them to PDF, and set up a printing routine for easy batch printing.
Description
In this recorded webinar, you will learn how to create automated reports using VBA. You will be able to automatically save the generated files to the designated network directory. Additionally, you will be taught how to produce the same reports in PDF format by modifying the source output. Finally, you will learn how to set up a printing routine so that you can easily print out batches of reports with just one click.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Create 10 reports from a single template all saved to the network drive using a single loop.
- Create 30 reports all saved to the network drive using a double loop.
- Create 10 PDF reports automatically.
- Create a printing routine that will print out 10 reports.
- Create a printing routine that allows the user to choose how many of each report they want to print out.
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: May 2023
Learning objectives
- Create a VBA looping construct from scratch
- Save a group of files to a directory of the users choosing
- Generate a batch of PDF reports with an Excel VBA procedure
- Generate a printing routing for a batch of financial reports in Excel