Mon 5 Nov 2007, 16:29Delegate Paul said...
Paul has attended:
Excel VBA Intro Intermediate course
Printer control in vba
can we use vba to tell printer to use colour?
Tue 13 Nov 2007, 16:09Trainer David said...
RE: printer control in vba
Paul,
Essentially yes you can, however it will depend on whether your printer supports colour printing.
When I last did I wanted to print something from Access. The way I did this was to send the data to Word and using VBA and then use VBA printing/layout/format commands to create a nicely formatted printable page. When doing this, you can opt to use colours or just mono for the items you wish to print.
Hope this helps
David
