Printing Seperate Excel Tabs as Seperate PDF documents

New Here ,
Feb 10, 2019 Feb 10, 2019

Copy link to clipboard

Copied

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.

TOPICS
Create PDFs

Views

178

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 08, 2022 Apr 08, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 08, 2022 Apr 08, 2022

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 12, 2022 Apr 12, 2022

Copy link to clipboard

Copied

Hello! Thank you. Here is my info:

Adobe Acrobat Pro DC  / Version 2022.001.20085

Windows 10 Home  / Version 21H2

Microsoft 365 Subscription

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Apr 08, 2022 Apr 08, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Apr 12, 2022 Apr 12, 2022

Copy link to clipboard

Copied

LATEST

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!

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines