Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Printer control in vba
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel vba courses - Printer control in vba
Resolved · Low Priority · Version Standard
Reply 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?
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
|