VBA Excel Saving a spreadsheet as PDF in three different ways
In this vid we look at making a spreadsheet save as a pdf via a button using VBA. There will also be a choice on how you wish to save the file to a PDF.
You will be able to save to a specific directory, hard coded.
You will be able to save to where the spreadsheet it self is saved.
and you will have a dialog box pop up and the user can choose where they want to save the pdf.
If you like this video then please like. If you had any issues with the coding please let me know in the comments and I will get back to you.
If you have any suggestions or issues you have had, let me know and we can look at making a video for you with a solution.
I am going to be doing lots more vids using VBA for both Excel and Access so make sure you hit the subscribe button :)