Printing Seperate Excel Tabs as Seperate PDF documents

[ianp2121494]

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.

[cody23964649vwen]

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]

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?

[cody23964649vwen]

Hello! Thank you. Here is my info:

Adobe Acrobat Pro DC  / Version 2022.001.20085

Windows 10 Home  / Version 21H2

Microsoft 365 Subscription

[Brad @ Roaring Mouse]

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

[cody23964649vwen]

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!

[Sabine2719173552rx]

Hi 

this sounds absolutely amazing and will save me so much time! I have a spreadsheet with 60 tabs that I print each tab at the moment. 

I tried and follow it along it comes up with Run-time error 1004 

Select Method of Worksheet class failed

When I click into debug it comes up highlights Sheet.Select in yellow

How do i fix this?