Buy the Simple Sheets Invoice Template (all purchases help support this channel)
https://www.simplesheets.co/a/2147525377/v7Aj9zMx
Download the featured invoice template here
https://www.bluepecantraining.com/excel-invoice-template/
Full playlist for this video series: https://youtube.com/playlist?list=PLA3JEasWtYad0OeX78k0gFhxm5qnnaD57
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
------------------------