excel vba courses - Printer control in vba

The UK's most regular instructor-led training courses.
Training information: excel vba courses · Excel training courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Printer control in vba

Paul has attended:
Excel VBA course

by - delegate Paul [2 posts] (2007 Nov 5 Mon, 16:29) Reply

can we use vba to tell printer to use colour?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: printer control in vba

by - trainer David gold contributer [428 posts] (2007 Nov 13 Tue, 16:09) Reply

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

· Advanced Excel Training - takes you to the next level
· Benefits of learning about Excel charts
· Do You Really Need Excel VBA Training?
· How to check for and reduce errors in Microsoft Excel
· Compare Different MS Excel Training Methods

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Rate this page: