View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cimjet[_3_] Cimjet[_3_] is offline
external usenet poster
 
Posts: 157
Default Print to PDF format

Hi Everyone
I'm using XL03 and Primo PDF driver to print.
Sub PrintPDF()
ActiveWorkbook.Save
Application.ActivePrinter = "PrimoPDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"PrimoPDF on Ne00:", Collate:=True
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
End Sub
Is it possible to send the information to change the name of the file, presently
it use the same name as my XL file.
Also I need to press a Print (OK) button on a pop-up Primo menu, if I could
override this setting, it would be great.
Thank you for your help
Regards
Cimjet