Can anyone assist me with some code for Excel 2003 which without any other
program intervention prints a worksheet from Excel to PDF?
--
Mark

Does changing printer count as intervention?

If no, then you may want to try www.primopdf.com

It installs as another printer.

Mark wrote:

Can anyone assist me with some code for Excel 2003 which without any other
program intervention prints a worksheet from Excel to PDF?
--
Mark

--

Dave Peterson

If you are familiar with ActiveX components, the ultimate solution
will be to use OGDIPICTURE. It is an excellent components full of
capabilities including creating PDF without printers stuff

Regards
Avi

Adobe Acrobat will do it.

But I know that from a co-worker, not from personal experience.

I don't know if Acrobat installs some Reference libraries so you can
save to PDF from within VBA though.

wrote:
Adobe Acrobat will do it.

But I know that from a co-worker, not from personal experience.

I don't know if Acrobat installs some Reference libraries so you can
save to PDF from within VBA though.


Indeed it will , but at a price $$$

--
Message posted via http://www.officekb.com

Indeed it will , but at a price $$$

It's only $80.

The student verison is $60.

See:
http://sfsubookstore.com/catalog/adv...crobat&x=0&y=0