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

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

82.739 Lượt nghe
VBA - Save Invoice Worksheet as PDF - to Specific Folder | Filename Based on Cell Value
👍👍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 ------------------------