Formatted printing

[Beto]

Hi, I'm trying to print using coordinates, without using the excel
built-in printer scheme.
I'd do something like this on Visual Basic:

Private Sub CommandButton1_Click()
Printer.Height = 279 * 56.7
Printer.Width = 216 * 56.7
Printer.Copies = 1
Printer.CurrentX = 32 * 56.7
Printer.CurrentY = 55 * 56.7
Printer.Print "Testing"
Printer.EndDoc
End Sub

But this doesn't work as it doesn't recognize printer.

Is there a way to print in a more "raw" way using VBA?

Regards,

 

[Vasant Nanavati]

There is no Printer object in VBA and it is quite complicated to manipulate
printers using API calls. What exactly are you trying to accomplish? Why
can't you use PageSetup?

 

[Beto]

There is no Printer object in VBA and it is quite complicated to manipulate
printers using API calls. What exactly are you trying to accomplish? Why
can't you use PageSetup?

Hi,
The problem is that I have a dot-matrix printer to print a form. I
can't make the printing match the space lines by adjusting the row
height, I know I have more control using the way I mentioned, because
I tried it on VB. Is there any other way to adjust the space in Excel?

regards,