Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Print to PDF button which works great and renames the file to a
populated cell, but I want the code to also work with Adobe. This is what I have 'Application.ActivePrinter = "CutePDF Writer on CPW2:" 'ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ '"CutePDF Writer on CPW2:", Collate:=True Any suggestions? Thanks in advance -- Neall |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Refer the below link..
http://www.erlandsendata.no/english/...tchangeprinter If this post helps click Yes --------------- Jacob Skaria "Neall" wrote: I have a Print to PDF button which works great and renames the file to a populated cell, but I want the code to also work with Adobe. This is what I have 'Application.ActivePrinter = "CutePDF Writer on CPW2:" 'ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ '"CutePDF Writer on CPW2:", Collate:=True Any suggestions? Thanks in advance -- Neall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can't print to adobe acrobat | Charts and Charting in Excel | |||
Excel print to Adobe.pdf | Excel Programming | |||
Can only print ~3 pages from Excel to Adobe PDF | Excel Discussion (Misc queries) | |||
Print mult worksheets to Adobe | Excel Discussion (Misc queries) | |||
Print to Adobe Acrobat (2 ws to one file) | Excel Programming |