I use PDF995 - it is a print driver that creates a PDF file when you select
it in Excel. THen you push print and it will then ask for a filename. It
has functionality to auto name but I need the value of a cell to become the
file name. Any idea's how to tackle this?

I have code that will pull up the print dialogue box but I am not sure how
to get the value? The value is stored in cell C5 - consistently.

Any idea's?