Skip to main content
I
ianp2121494
New Participant
February 11, 2019
Question

Printing Seperate Excel Tabs as Seperate PDF documents

  • February 11, 2019
  • 2 replies
  • 8794 views

Hi,

    I have an excel spreadhseet with some 200+ tabs

Each is a statement between 2 and 4 pages long for an individual client.

Is there a way to print each of these as an individual PDF document, using the tab name as the document name so that I can send it separatly to each client.

I do not want to print one large document and spent hours cutting it to separate ones and I do not want to have to open a print each sheet individually.

I have tried the solution of opening "Create PDF" in the Acrobat ribbon of Excel and selecting Sheets under conversion Range and then selecting some of the sheets prior to clicking on "Convert to PDF". Either I am missing a step or this is NOT the solution.

Thanks in advance.

    This topic has been closed for replies.

    2 replies

    Brad @ Roaring Mouse
    Brad @ Roaring Mouse
    Adobe Expert
    April 8, 2022

    You will need to use a VBA script to do what you want.

    Here's the one I have used:

    In Excel, Create new VBA Module and copy/paste the following:

     

    Sub ExportSheetsPDF()
    Dim eachsheet As Worksheet
    Dim sheetname As String

    For Each Sheet In Worksheets
    Sheet.Select
    sheetname = Sheet.Name
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:="C:\Users\***username***\Desktop\" & sheetname & ".pdf", _
    openafterpublish:=False

    Next Sheet
    End Sub

     

    Save it and Run it on the open file

    This should work in both Windows and PC, as long as you set a correct path... in my examples we're saving to the Desktop, but you can use any valid path.

    Fot the Mac, your path should look like this:

    Filename:="/Users/***username***/Desktop/" & sheetname & ".pdf", _

     

    If you want to immediately Open your PDFs, change "openafterpublish" to True

     

    Of course, using a VBA script means you have to save your file as Macro-enabled, hence you will need to clear some permission/access roadblocks

      C
      cody23964649vwen
      New Participant
      April 12, 2022

      Hi, 

      Thank you. I will try your instructions. It's a bit overwhelming to me. I tried similar instructions a while back and messed something up because it didn't work. I really should have learned coding!

      C
      cody23964649vwen
      New Participant
      April 8, 2022

      I need the same thing. All tutorials don't work (choosing "sheets" in Excel). Maybe  they dicontinued the feature. 

       

      SOMEbody help! Please! I waste so much time saving each and every tab into their own pdf files.

       

      There must be a way to convert automatically, multiple tabs -keeping tab names- from an Excel workbook to individual pdf s

      try67
      try67
      Adobe Expert
      April 8, 2022

      What's the exact version number of the application (You can find it out by going to Help - About Adobe Acrobat)? What's your OS version? What's your Office version?

        C
        cody23964649vwen
        New Participant
        April 12, 2022

        Hello! Thank you. Here is my info:

        Adobe Acrobat Pro DC  / Version 2022.001.20085

        Windows 10 Home  / Version 21H2

        Microsoft 365 Subscription

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices