Point of Sale (POS) print in VBA (Excel)

[PedroMB]

Hi all,

Sorry about the english...

I like to know if I can't control printing in Excel(VBA) to a Point of Sale (POS) printer.
I like to make small tickets to control expenses, and I don't like to spend A4 paper.
Can I control automatic cut our page ending in VBA ?

Thanks for the help !

 

[ETID]

Is this happening in Word, Excel or Access?

 

[PedroMB]

Hello ETID!

I want to make the printing in Excel, directly from VBA code.

I want to use PrintOut command, but I don't know if I can control the Size of the ticket or the Cutting fungtion of the printer.

I don't want to print 3 lines and use paper for 30 (example).

 

[lestatdelioncourt]

You can use the printer contol language. (This should be in the printer manual).

Then you can send the termination string and printer cut function.

I have got some sample code, somewhere I will try and dig it out

 

[ETID]

It's been a long time, but I've used something like....


open "lpt1" for output as #1 'you might need "lpt1:"
print #1,chr$(the_ascii_number_of_your_1st_control_char)
print #1,chr$(the_ascii_number_of_your_2nd_control_char)
etc...
close #1

 

[PedroMB]

Hello ETID!

Thnaks for the Tip. Now I can control the printing in Excel.
This remember the old Turbo Pascal Programing, when everything must be done by the programer.

I tried the code in Excel and works fines in the network printers.

Thanks very must for the perfect tip...