Automation & Reports
Let Excel react on its own, gather data from a folder, and send the finished report out the door.
The first lesson is free — no account needed.
About this course
Automate Excel reports with VBA from start to finish. You let Excel react to worksheet and workbook events, loop through a folder with Dir, consolidate many workbooks into one, build a report sheet, export it to PDF and send it through Outlook, then make the whole run fast.