Sep 6, 2001 #1 octane Programmer Aug 19, 2001 12 MX My paper size = 8 1/2 X 5 1/2 inches I need to print on it I know that .papersize exist I tryed this code Printer.ScaleMode = vbCentimeters Printer.PaperSize = xlPaperUser PrintRoutine Printer Printer.EndDoc but I it doesn't work what's wrong with the code???
My paper size = 8 1/2 X 5 1/2 inches I need to print on it I know that .papersize exist I tryed this code Printer.ScaleMode = vbCentimeters Printer.PaperSize = xlPaperUser PrintRoutine Printer Printer.EndDoc but I it doesn't work what's wrong with the code???
Sep 6, 2001 #2 JustinEzequiel Programmer Jul 30, 2001 1,192 PH Have you tried setting the printer object's height and width properties? Upvote 0 Downvote
Sep 7, 2001 Thread starter #3 octane Programmer Aug 19, 2001 12 MX I am working with this code at this time With Printer .ScaleMode = vbCentimeters On Error GoTo Carta .PaperSize = vbPRPSUser '.Width = 21.5 '.Height = 14 PrintRoutine Printer .EndDoc End With SalirImprimir: Exit Sub Carta: Printer.PaperSize = vbPRPSLetter PrintRoutine Printer Printer.EndDoc Resume SalirImprimir but it does not work any way I think that depends on the printer´s driver Upvote 0 Downvote
I am working with this code at this time With Printer .ScaleMode = vbCentimeters On Error GoTo Carta .PaperSize = vbPRPSUser '.Width = 21.5 '.Height = 14 PrintRoutine Printer .EndDoc End With SalirImprimir: Exit Sub Carta: Printer.PaperSize = vbPRPSLetter PrintRoutine Printer Printer.EndDoc Resume SalirImprimir but it does not work any way I think that depends on the printer´s driver