Dot matrix printer

Andris

New Member
Joined
Aug 24, 2002
Messages
5
I have another one of this difficult questions: I want to print a single cell contents to the attached dot matrix printer on a legal form !!! without the printer feeding through the whole page !!! after each cell. This way I can manually line feed (turning the knob) to the appropriate part of the form and let Excel print the next piece of text. I made the whole mechanism for the data part but I don't see how I can connect with the printer. Someone suggested using the VB Printer.Print command, but it is not available in VBA is it ?

So in fact the question comes down to How do I use VB6 objects etc in VBA for excel...
This message was edited by Andris on 2002-08-29 01:55
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

lbass

Board Regular
Joined
Aug 15, 2002
Messages
104
You had no replies when I looked.
If I under stand you - you want to fill in the blanks on a pre printed form?

I'm new to this and would not have replied if someone else had.

The way I have done this is to by trial and error changed the width and height of cells so that certain cells would print in the correct places on the form.

Then type the information you want into these cells. Then print. It is a one shot deal and you don't get to twist the little knob.

Sorry - I'm probably too dumb to understand what you want to do but no one else had given any ideas so I tried.
Ll
 

Forum statistics

Threads
1,148,224
Messages
5,745,472
Members
423,953
Latest member
MrC54

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top