VBA - Save Invoice Worksheet as PDF - to Specific Folder | Filename Based on Cell Value

Buy the Simple Sheets Invoice Template (all purchases help support this channel)
https://www.simplesheets.co/a/2147525...

Download the featured invoice template here
https://www.bluepecantraining.com/exc...

Full playlist for this video series:    • Create an Automated Invoice Template,...  

This tutorial is part of a series of tutorials that demonstrate how to create an automated invoice system in Microsoft Excel. This video looks saving the invoice worksheet as a pdf.

Other videos in this series show you how to write VBA macros that
1) Automatically generate the next invoice number
2) Add the invoice details to a record of invoices
3) Save the invoice as an Excel workbook
4) Automatically email a PDF version of the invoice to the customer

Table of Contents:

00:00 - Introduction
01:48 - Declaring the variables for the VBA macro
04:38 - VBA code for saving and Excel worksheet as pdf
06:48 - VBA code to copy invoice details to the invoice tracker and create hyperlink to pdf
10:32 - Create a button to run the macro
------------------------