| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a word doc from Excel
Calling the finest minds of this group:
I have a macro that is editing a word doc, that part is fine. The problem is how to change the printer settings to use the colour printer! Does anyone have any ideas? Thanks, Peter |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print a word doc from Excel
Look at Excel VBA help for application.ActivePrinter
You can get the string the colour printer by selecting it manually, then in the immediate window you can do ? Application.ActivePrinter -- Regards, Tom Ogilvy "Peter" wrote: Calling the finest minds of this group: I have a macro that is editing a word doc, that part is fine. The problem is how to change the printer settings to use the colour printer! Does anyone have any ideas? Thanks, Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | Excel Discussion (Misc queries) | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | New Users to Excel | |||
| Print a word doc from Excel | Excel Programming | |||
| excel * word won't print | Excel Discussion (Misc queries) | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
![Peter[_61_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
