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" wrote in message ...
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