?
Solved

Single worksheets from multiple spreadsheets converted to 1 pdf file

Posted on 2011-09-08
2
Medium Priority
?
227 Views
Last Modified: 2012-05-12
I have 3 Excel files.  I want to select one worksheet (tab) from each file and save it as a single pdf.  Is this possible?
0
Comment
Question by:3wits
2 Comments
 
LVL 6

Accepted Solution

by:
theKashyap earned 2000 total points
ID: 36505287
Programatically? Manually?
Manually, you can always just install some pdf creator (CutePdf, Bullzip, Nitro,...), then open all 3 excels and print required sheets one by one. Bullzip and Nitro both support "appending to existing file" option.
0
 
LVL 3

Expert Comment

by:evedder
ID: 36505311
well you can drag the sheets between workbooks, so you can drag the tabs you need into 1 single workbook, then in print configuration you can select "print all workbook" and then you print it as a pdf,

if you are looking for a programatic solution you can use java (POI and Itext) or even php
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question