How can I set the Adobe PDF printer's location on xp so that the file printed will automatically be in the same folder where the document being printed is in, that is, if c:\xls\xl1.xls is to be printed to pdf, it will be printed without prompting as c:\xls\xl1.pdf? If the printed cannot be so configured, how can this be done in VBA? All that happens now is the file is printed with no prompting to "My Documents" which is the location of the Adobe PDF printer in the printer properties.

Thanks,

Malcolm