![]() ![]() This line of code is for exporting the excel file as PDF and making it ready for print. ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, filename:=loc Here, we save our file in E: on our computer and name the file Workbook. This line is for the location and the pdf file name. So we name our procedure Print_Workbook(). Sub is a part of code that is used to handle the work in the code but will not return any value. VBA Code Explanation Sub Print_Workbook() This is because the file is now ready for printing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |