Macro to determine attached template

zippyaus · #1 03-02-2010, 02:05 AM

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

Is it possible to determine the template path via a macro call?

Any help would be greatly appreciated

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