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

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

Print to PDF format
 

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

Print to PDF format
 

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
"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



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.

--
Garry

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

Print to PDF format
 

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

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



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.

--
Garry

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