function to print to PDF and save PDF file

[mark kubicki]

can i build a function that both prints a worksheet to a PDF file, but also
saves it under a name that the function determines

thanks in advance
mark

 

[Tom Ogilvy]

You would need adobe acrobat/distiller or some 3rd party software that
provides a "PDF print driver"

 

[Harlan Grove]

You would need adobe acrobat/distiller or some 3rd party software that
provides a "PDF print driver" ....

Even if you were saving as an .XLS file, you can't use a function called as
a udf to save the file.

As for saving in PDF format, one spreadsheet program or one Office suite is
never enough. OP could always download and install OpenOffice along with
MSFT Office. OO can generate PDF files itself (and Macromedia Flash .swf
files too).

 

[mark kubicki]

(presuming that i already ave that software in place (Adobe)..

i know how to create the function to get to the print screed (adobe) but
not to save the doc...

Mark Kubicki
(e-mail address removed)

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!