Maybe you could incorporate some of Jim Rech's code:

http://groups.google.co.uk/group/mic...ee5b61dff842df

or
http://snipurl.com/mrp0


cvach@mycaf.com wrote:
>
> I have a portion of a sheet that I want to print/save as a pdf to a
> folder on my hard drive. The folders location is C:\Documents and
> Settings\Compaq_Owner\Desktop\Invoices. I also want the file name to
> be the value found in cell j19 on the "PO Form" worksheet. Any help?

--

Dave Peterson