Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatted printing
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatted printing
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? -- Vasant "Beto" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatted printing
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ...
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? -- Vasant 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, -- Beto "Beto" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Formatted Cells | Excel Discussion (Misc queries) | |||
Excel color-formatted cells printing in black | Excel Worksheet Functions | |||
now get message "disk is not formatted or formatted for Mac" | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |