View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Print to PDF format

Cimjet brought next idea :
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


Does your PrimoPDF driver support VBA? IOW, is there a toolbar menu or
VBA project for this? If so, perhaps the entire process can be
automated. (May require a SDK be avaiable) Otherwise, what's wrong with
allowing users to use its normal dialog for for entering a filename and
clicking the OK button?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc