![]() |
|
#1
|
|||
|
|||
|
Hi
N00b question. I am trying to create a print macro that will determine what template the document is attached to and based on that print single sided or duplex. In plain text If document template is C:\Program Files\Microsoft Office\Templates\Label.dot print single sided else if document template is C:\Program Files\Microsoft Office\Templates\Letter.dot print duplex I have go the printing part sorted Code:
Sub PrintDuplex()
Dim iDuplex As Long
iDuplex = GetDuplex 'save the current setting
SetDuplex 3 'set for vertical binding
ActiveDocument.PrintOut Background:=False
SetDuplex iDuplex 'restore the original setting
End Sub
Sub PrintSimplex()
Dim iDuplex As Long
iDuplex = GetDuplex 'save the current setting
SetDuplex 1 'set for vertical binding
ActiveDocument.PrintOut Background:=False
SetDuplex iDuplex 'restore the original setting
End Sub
Any help would be greatly appreciated |
| Tags |
| duplex, printing, template |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to determine a user's mailbox size limit? | enviroko | Outlook | 3 | 05-13-2010 07:02 AM |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
| Problem with MS Outlook when open email with attached file | moniros | Outlook | 0 | 03-01-2009 12:50 AM |
| Outlook xp slow when Browsing to attached a file | jmelgar1 | Outlook | 0 | 09-23-2008 01:49 PM |
Determine age by using birthdate
|
gdodson | Excel | 1 | 08-11-2006 09:27 PM |