Save Excel Workbook or Sheet as PDF and AUTOMATE it with VBA
If you have recurring tasks where you need to save your reports as PDF, doing it weekly/monthly can be worrying, because you always need to repeat the same steps. Instead, automate this process. If this is the case, this video will be very useful for you. It is a tutorial on how to automate saving an Excel workbook or Excel sheet to a specific folder; give them the name and the current date. With VBA.
00:00 Intro
00:26 Save Excel WorkBook as PDF in a specific folder with VBA
05:15 Save it with Current Date
06:52 Add the second part of the name to this pdf with vba
07:51 Save Excel SHEET as PDF in a specific folder with VBA with current date
10:07 How to Save WorkBook with VBA
11:00 Add Developer Tab
11:27 Add Buttons and Assign Macro to them
Thank You for Visiting my Channel ❤️
#MyExcelLife #ExcelTutorials #exceltips #excel @MyExcelLife #excelonline #excelfree
Watch video Save Excel Workbook or Sheet as PDF and AUTOMATE it with VBA online without registration, duration hours minute second in high quality. This video was added by user My Excel Life 01 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6 once and liked it people.