There have been a few topics about this however I can't see to make any of the other solutions do quite what I need the app to do. I need to export a report to a pdf file to a hardcoded location. We are running Access97 and have the PDF Factory Pro installed. I want this to be automated so when the user hits the button it creates the PDF without opening up a dialog box. Suggestions?