Hi. First let me say that this is a great site!
My general question is: How do I save several reports using VBA to .pdf files?
My specific need:
I create several (+200) reports with a form button. A form button queries data and generates a report from each record. I use a Do Until "recordset".eof Loop to open a query that goes through each record, runs a report and creates a .snp of each report to one specific directory. I wish to save these as .pdf reports as opposed to .snp with the same "One Click" method.
I use Acrobat Distiller. I cannot get code that works. I've set printer to Distiller in the registry but when I run it I get an Acrobat Dialog box. I tried turning this off in Distiller. It does not. I tried using SendKeys to run and close the box automatically, but I couldn't get that to work. I also have looked at the various solutions on Tek-Tips. Unless I overlooked something, none seemed to address this specific issue.
Thanks! Looking forward to your responses.
Mick
My general question is: How do I save several reports using VBA to .pdf files?
My specific need:
I create several (+200) reports with a form button. A form button queries data and generates a report from each record. I use a Do Until "recordset".eof Loop to open a query that goes through each record, runs a report and creates a .snp of each report to one specific directory. I wish to save these as .pdf reports as opposed to .snp with the same "One Click" method.
I use Acrobat Distiller. I cannot get code that works. I've set printer to Distiller in the registry but when I run it I get an Acrobat Dialog box. I tried turning this off in Distiller. It does not. I tried using SendKeys to run and close the box automatically, but I couldn't get that to work. I also have looked at the various solutions on Tek-Tips. Unless I overlooked something, none seemed to address this specific issue.
Thanks! Looking forward to your responses.
Mick
