| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing via vba
I have this which is in a bit of code activated by a button. Charts("Overall Days By Period").PrintOut but this just prints straight out to whatever printer is currentl selected. Is there a way to change this so that it brings up th dialog box which asks things like which printer, how many copies etc -- neowo ----------------------------------------------------------------------- neowok's Profile: http://www.excelforum.com/member.php...nfo&userid=594 View this thread: http://www.excelforum.com/showthread.php?threadid=27202 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
printing via vba
hi,
Application.ActivePrinter = "\\OKI-01\OKI-HP4000-01 on Ne01:" Application.activePrinter would be the command. the the server file path to the printer. the above is from my network. you will have to find out what your's is. Regards Frank -----Original Message----- I have this which is in a bit of code activated by a button. Charts("Overall Days By Period").PrintOut but this just prints straight out to whatever printer is currently selected. Is there a way to change this so that it brings up the dialog box which asks things like which printer, how many copies etc? -- neowok ---------------------------------------------------------- -------------- neowok's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=272024 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
printing via vba
Application.Dialogs(xlDialogPrint).Show
-- Regards, Tom Ogilvy "neowok" wrote in message ... I have this which is in a bit of code activated by a button. Charts("Overall Days By Period").PrintOut but this just prints straight out to whatever printer is currently selected. Is there a way to change this so that it brings up the dialog box which asks things like which printer, how many copies etc? -- neowok ------------------------------------------------------------------------ neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940 View this thread: http://www.excelforum.com/showthread...hreadid=272024 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
printing via vba
Hi Tom Ogilvy, Great. Thanks S.Sures -- s_u_res ----------------------------------------------------------------------- s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567 View this thread: http://www.excelforum.com/showthread.php?threadid=27202 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
| Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
| Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
| Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
| Printing? Worksheets not printing the same on multiple pc's! | Excel Programming | |||
![neowok[_77_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
