Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Printer control in vba
excel vba courses - Printer control in vba
Resolved · Low Priority · Version Standard
Paul has attended:
Excel VBA Intro Intermediate course
Printer control in vba
can we use vba to tell printer to use colour?
For upcoming training course dates see: Pricing & availability
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
|
