On Thu, 4 Sep 2003 11:33:31 +0200, "Paul Bleijlevens"
wrote:

How can I save a worksheet to a PDF file from within VBA without that the
program is prompting for a file name?????
In other words, I want to save an Excel sheet into a PDF file and the name
for the PDF file has to be given through the macro so the user doesn;t have
to give te name.....

Try www.fineprint.com