Rng.ExportAsFixedFormat Type:=xlTypePDF, _ 'Create and assign variables Dim saveLocation As String Dim rng As Range The macro below saves a specified range as a PDF. Selection.ExportAsFixedFormat Type:=xlTypePDF, _ The following code saves only the selected cells. Sometimes, we only want to save a small part of a worksheet to a PDF. Sub SaveActiveWorkbookAsPDF()ĪctiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _ To save all the sheets from a workbook use the following macro. SaveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"ĪctiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ 'Create and assign variables Dim saveLocation As String The following code saves the selected sheets as a single PDF. From a VBA perspective, it is the ExportAsFilxedFormat method combined with the Type property set to xlTypePDF that creates a PDF. This section contains the base code to save Excel as PDF from different objects (workbooks, worksheets, ranges and charts). Saving Excel workbooks, sheets, charts and ranges as PDF Selecting specific worksheets before saving as PDF.Saving Excel workbooks, sheets, charts and ranges as PDF.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |