Printing with coordinates

B

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

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?

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

Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top