Worksheet.ExportAsFixedFormat is the command used here which can also be used for converting the Excel to other formats. Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True ISh.ExportAsFixedFormat Type:=xlTypePDF, Filename:=pdfFileName, _ PdfFileName = ThisWorkbook.Path & "\PDF_File_" & VBA.Format(VBA.Now, "dd_mmm_yyyy") & ".pdf" ![]() 'Visit to get more Free & Fully Functional VBA Codesĭim iSh As Worksheet, pdfFileName As String Before this step, you can also define Print area that is explained in the next code in this page. Use this Excel VBA save as PDF code to convert the Excel to PDF document. So, it becomes important for them to print or create PDF as the final version for future hard copy records. In many shops, the invoices, purchase bill, inventory details, balance sheet are all maintained in Excel. So, let’s learn what the available methods to print an Excel are and also how to automate a print process. ![]() Just like printing a PDF, Word document the Excel reports, dashboards charts are also sent to printer to have a hard copy. This article provides code for creating PDF from Excel & Vba print macro Excel 2010 or versions less than that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |