| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print format | Excel Programming | |||
| how to format the print? | Excel Programming | |||
| How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
| Print Format | Excel Programming | |||
| worksheet print format | Excel Worksheet Functions | |||
![Cimjet[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
