Dot matrix printer

[Andris]

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

 

[lbass]

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