

From what I read, I think these values are set in the registry. If I could change these settings automatically I think it would do exactly what I want. Looking at the printer preferences I can set a default folder for Generated PDF Files, and there are options to overwrite, use a default filename, open after creating, etc. This works fine, but I'd like to be able to direct the output to variable directories and set the file name without user input. (I can only use an older version of Excel, so the ability to export directly from Excel to a PDF is unfortunately not an option.) I'm currently printing to the Foxit Reader PDF printer. I'd like to be able to create PDF files by printing from an Excel macro. I've just upgraded to the latest version of the Foxit reader.
