I am using Excel 2003.

I am trying to output a print area from my spreadsheet to a PDF file, but I
can't seem to find a way to automatically or even semi-automatically specify
the filename. I generate the path and filename in Excel.

I tried the PrintToFile option of the Printout method, but it wound up
prompting me to disable a font feature in Acrobat. I got cold feet at that
point because of the sensitivity to changing settings in my work
environment. I'm not sure PrintToFile would get me PDF anyway.

Since I couldn't find a way to automatically enter the filename, the
intention now is to use copy and paste when the Acrobat printer prompts for
a filename. I copy the range that includes the filename, and then start my
VBA routine. VBA opens up the Acrobat printer and prompts for a filename,
but the paste command is grayed out. I can paste it into a Word document,
but not into the filename box for the Acrobat printer.

Suggestions?