Save multiple sheets to .pdf

by

Start by selecting the sheets you want to combine:

ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "C:\tempo.pdf", Quality:= xlQualityStandard, IncludeDocProperties:=True, _
     IgnorePrintAreas:=False, OpenAfterPublish:=True

More Related Contents:

  1. Excel VBA to Export Selected Sheets to PDF
  2. excel to pdf ignores print area and calls printer
  3. Extract Data from PDF and Add to Worksheet
  4. Excel VBA – How to add dynamic array formula
  5. How can I concatenate strings in VBA?
  6. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  7. Loading addins when Excel is instantiated programmatically
  8. Excel’s fullname property with OneDrive
  9. Trying to use variables as values vba to sql
  10. Copy Excel range as Picture to Outlook
  11. VBA (Excel) Dictionary on Mac?
  12. Return RGB values from Range.Interior.Color (or any other Color Property)
  13. Refresh Excel VBA Function Results
  14. excel VBA run macro automatically whenever a cell is changed
  15. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  16. Translate text using vba
  17. Copy sheet and get resulting sheet object?
  18. Sending mail using Outlook where the Send method fails
  19. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  20. Using a variable for row in (row,column) for a range in VBA
  21. Unicode string literals in VBA
  22. How to get the path of current worksheet in VBA?
  23. Excel VBA to match and line up rows
  24. Create a new object using the text name of the class
  25. How to open a workbook specifying its path
  26. Application.WorksheetFunction.Match method
  27. Excel Hide/Show all tabs on Ribbon except custom tab
  28. Macros Not Showing Up in Macro Table
  29. Excel telling me my blank cells aren’t blank
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment