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

P

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.
 
B

Bob I

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

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!
 
B

Bob I

He already has Adobe Acrobat Pro 9.
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!




:
 
P

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top