View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
igorek igorek is offline
external usenet poster
 
Posts: 38
Default Printing to File (PDF)

Hi All,
Here is the issue i'm facing, if anyone could help i would really appreciate.

I have a file with number of ranges that i need to print. Macro activates
those ranges and sends every single one to the printer. Now i want to instead
of printing to printer, print to PDF file usind PDF995. Unfortunatelly, for
every range printed it always promts me to name the pdf file.
Is there a way to specify pdf file name in the code to avoid the prompt?

Thanks
Igor