Does anybody have any code that saves the active workbook as a PDF file?

I'm currently using sendkeys but I'm sure there will be a better way of
doing it?

--
P

Hi Worthy

See
http://www.dailydoseofexcel.com/arch...eator-take-ii/


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Worthy" wrote in message ...
Does anybody have any code that saves the active workbook as a PDF file?

I'm currently using sendkeys but I'm sure there will be a better way of
doing it?

--
P

Worthy:

You might want to look at our XL PDF Wizard Excel Add In, which can allow
you to automate output of Excel files to PDF documents using any number of
readily used PDF printer drivers, either a single worksheet, whole workbook
with the ability to script the output and combine it with Word documents and
other PDF files. You'll find it in the Developer Tools area of our Web.
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Worthy" wrote in message
...
Does anybody have any code that saves the active workbook as a PDF file?

I'm currently using sendkeys but I'm sure there will be a better way of
doing it?

--
P

SA,

Where is the 'Developr Tools' area? can you post me a link to this PDF
Add-In?

"SA" wrote:

Worthy:

You might want to look at our XL PDF Wizard Excel Add In, which can allow
you to automate output of Excel files to PDF documents using any number of
readily used PDF printer drivers, either a single worksheet, whole workbook
with the ability to script the output and combine it with Word documents and
other PDF files. You'll find it in the Developer Tools area of our Web.
--
SA
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Worthy" wrote in message
...
Does anybody have any code that saves the active workbook as a PDF file?

I'm currently using sendkeys but I'm sure there will be a better way of
doing it?

--
P