Print to PDF format

[Cimjet]

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

 

[GS]

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?

 

[Cimjet]

Hi Garry
PrimoPDF is a frreware on the Internet and I don't think it support VBA.
I'm just trying to automate the process.
As for using the Primo dialog menu, it's in the background behind Excel, you
need to minimise excel to get to it.
Regards
Cimjet

 

[GS]

Cimjet was thinking very hard :

Hi Garry
PrimoPDF is a frreware on the Internet and I don't think it support VBA.
I'm just trying to automate the process.
As for using the Primo dialog menu, it's in the background behind Excel, you
need to minimise excel to get to it.
Regards
Cimjet

So, then, why not use a freeware PDF addin that runs "in-process" with
Excel? Try DucuDesk.com's freeware version (deskPDF) of their MS Office
addin. Others are CutePDF Writer, DocuCom PDF Driver. These all put
their own menus in MS Office apps and so can be automated via executing
their menus or simply change the printer so the user gets a dialog
within Excel.

 

[Cimjet]

Hi Garry
Thank you very much.
You Guys are great. The knowledge base on these newsgroups is phenomenal.
Have a nice day
Cimjet