Convert multiple excel files with multiple sheets to PDF - how?

11-04-09, 07:46 PM

Phil J W

Can this be done? I have about 500 store specific excel files, with 2 sheets
each. I'd like a quick way to PDF all of them, not as one big file, but as
individule PDFs. Here at the office we are using Office 2007 and Adobe
Acrobat 9 Pro...thank you.

11-04-09, 09:25 PM

Bob I

What happens when you select the Files in Windows Explorer, and then
r-click on them and pick Convert to PDF?

Phil J W wrote:
[..]

11-05-09, 07:53 AM

Neuroner

Greetings Phil

I'd download CutePdf from the net. This installs a printer on your system, and
anything printed will become a .pdf file. When printing, it promts you for
file
name, and then creates the file. Simple, free and fast.

Simply select all files, hit print, and Accept the auto-generated name. Then,
select all files again, and hit F2 to rename them all at one time.

Good luck!

"Phil J W" wrote:
[..]

11-05-09, 02:16 PM

Bob I

He already has Adobe Acrobat Pro 9.

Neuroner wrote:
[..]

11-05-09, 07:29 PM

Phil J W

when i right click and convert to adobe pfd, that works, it just doesnt take
all the sheets in the file. just the active sheet.

"Bob I" wrote:
[..]

11-05-09, 07:43 PM

Bob I

perhaps create an AutoIT script to open the file, group sheets, print to
adobe file, and close. (AutoIT is available for the download at the
authors website)

Phil J W wrote:
[..]

Similar Threads
export multiple sheets to multiple excel files I have a workbook with approx 30 sheets. I am trying to figure out how to save each sheet as it's own workbook (using the name of the worksheet as the file name) without...
Importing EXCEL files with multiple sheets I have often imported contacts from a single EXCEL spreadsheet into Outlook 2003 Contacts. I just tried to do so again but the import process did not work correctly. I then...
Multiple tables output to multiple sheets in single excel workbook Hi all, Been a while since I've done any access dev, and I can't for the life of me remember how to do this. I have 3 tables I need to export to Excel, preferably in one...
Create seprate files from multiple sheets in excel Hi All, Here is what I need to do: I have 2 excel workbooks. For simplicity lets assume them to be BookA and BookB. BookA has 20 odd worksheets (say s1, s2..........s20)...
How to generate excel files with multiple sheets? I'm generating an excel file using the OWC, on the server side. I need to create an excel file with more than one sheet. Here's the code (C#)...