Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatically print to PDF from within Macro

Status
Not open for further replies.

tberube

MIS
Jun 7, 2001
1
US
I have a macro where the last command is OpenReport. My desire is to set the View option to "Print" and to print the report to Adobe PDF Writer. Right now, when the macro runs, the OpenReport command results in the opening of the print dialogue box in which I can change the filename and location to which I want to save the PDF file.

Is there a way to pre-set or call the filename and save location from within a macro so that the file is automatically created and the print dialogue box never opens? I need a way to print to the PDF so that the user does not have be present to enter the filename and click "save" in the print dialogue box to create the file.

terry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top