ExcelBanter - Printing with coordinates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Printing with coordinates (https://www.excelbanter.com/excel-programming/283380-printing-coordinates.html)

Printing with coordinates

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,
--
Beto

Printing with coordinates

On Sun, 23 Nov 2003 14:26:02 -0300, Beto wrote:

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?

Doesn't nobody knows???? I need it kind of fast :)

Regards,
--
Beto