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.
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
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?
Hello! Thank you. Here is my info:
Adobe Acrobat Pro DC / Version 2022.001.20085
Windows 10 Home / Version 21H2
Microsoft 365 Subscription
Copy link to clipboard
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:
Dim eachsheet As Worksheet
Dim sheetname As String
For Each Sheet In Worksheets
sheetname = Sheet.Name
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:="C:\Users\***username***\Desktop\" & sheetname & ".pdf", _
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
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!