Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
'' Excel app no longer works
vNam = Cells(2, 7).Text + "V" 'board voltage pPath = "D:\ANALOG\HVREG\Boards\TITANTWO\TT_C\Jumpers\ " ActiveSheet.Shapes(1).Select ' cannot get printer to work, and no useful help ' ALWAYS wants to print to f'ing "My Documents" no matter what ' AND to add insult to injury, it asks for file name '' THIS USED TO WORK Application.ActivePrinter = "Acrobat PDFWriter on FILE:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, _ ActivePrinter:="Acrobat PDFWriter on FILE:", printtofile:=True, _ Collate:=False, PrToFileName:=pPath + vNam ' the following scheme does not work either Application.ActivePrinter = "Acrobat PDFWriter on FILE:, PrToFileName:=pPath + vNam" Kill pPath + vNam 'only PDF left ' END END Help, please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double-sided printing and printing entire workbook in one go. Macro to help ... ?? | Excel Programming | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |