Auto PDF

[mjwillyone]

Dear Friends,

I am attempting to find a way (by the use of a Macro) to create a PDF of all of the tabs(pages) of a workbook. I would like the name of each PDF to match the tab name.

Each tab contains employee information I wish to send them by e-mail by attaching the PDF manually.

Can anyone help me?

[royUK]

Which version of Excel?
Which PDF software?

[arthurbr]

Hi
Ron de Bruin has some solutions at this site

[mjwillyone]

I am using Excel 2007. I am using Acrobat 8, though 6+ should work.

Thanks,
Mike

[arthurbr]

Have you checked the link I provided ?

[royUK]

You need to download & install the pdf addin for Excel 2007 then read the page that Arthur pointed you to

[shg]

No need for the add-in if you have Service Pak 2 installed ...