Back to Browse

Excel VBA Save Range to PDF

26.8K views
Jan 30, 2022
11:26

This video displays VBA code that will save a Range on an Excel Worksheet to a PDF File on a Network Drive with the file name being a Cell Value and Today's Date. To do this a method called "ExportAsFixedFormat" is used within VBA. This method has several optional parameters that we can use to define things like the file name and whether or not to use set print ranges. Learn More about Excel VBA & Macros with this Book on Amazon: https://amzn.to/3xnqT6R Get a Microsoft Office 365 Personal Subscription with this Amazon link: https://amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links. #ExcelVBASaveRangeToPDF #ExcelVBAExportAsFixedFormat #LearnExcelVBA

Download

1 formats

Video Formats

360pmp414.5 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Excel VBA Save Range to PDF | NatokHD