👍👍This invoice is free for you to use - no strings attached. However, if you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Alternatively 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
------------------------