Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

papersize???

Status
Not open for further replies.

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???
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top