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

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

--
Regards,
Tom Ogilvy

"mark kubicki" wrote in message
...
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" wrote...
You would need adobe acrobat/distiller or some 3rd party software that
provides a "PDF print driver"
....
"mark kubicki" wrote in message
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

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

(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


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