Microsoft Office Document Image Writer default to TIF?


  • We have MS Office 2003 on multiple servers.


    In my Access program I have a button which runs the Microsoft Office Image Writer.


    The problem with this is every time the program is run, it ONLY allows .MDI to be selected from the File Type:  I tried having the Network Admin set the default on the Image Writer to TIF, but when a user runs the access program and clicks the button it still only allows them to select .MDI.


    So, I was wondering if there was some VBA code I could use to have it automatically select TIF for the user when they click the button.  Is this possible?


    I have the following code so far:


    'Stores the users current's printer in a variable

    strDefaultPrinter = Application.Printer.DeviceName


    'Assigns the Image Writer Printer as the user's default printer

    Set Application.Printer = Application.Printers("Microsoft Office Document Image Writer")


    'Restores the user's original default printer

    Set Application.Printer = Application.Printers(strDefaultPrinter)

    viernes, 31 de agosto de 2007 22:04

Todas las respuestas