I'm trying to make a subroutine that prints a report as a PDF to a preselected folder using Adobe Acrobat 6.0. I've figured out that in order to accomplish this, I first need to create a registry key located in HKEY_CURRENT_USER\Software\Adobe\Acrobat Distiller\PrinterJobControl\.
The name of the key has to be the destination of the application doing the printing, so in this case, "C:\Program Files\Microsoft Office\Office\msaccess.exe" (without the quotes). And the value for this key has to be the location and name of the PDF being created, which will be stored in a variable called strPath.
So I guess what this boils down to is a matter of using VBA to create a single key in the registry. Unfortunately, I can't figure out how to do that. Can anyone help?