Tags: access, button, default, document, image, microsoft, msdn, multiple, office, program, runs, servers, sharepoint, software, tif, writer

Microsoft Office Document Image Writer default to TIF?

On Microsoft » Microsoft SharePoint

1,667 words with 1 Comments; publish: Wed, 09 Jan 2008 03:39:00 GMT; (30046.88, « »)

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)

All Comments

Leave a comment...

    • You should probably ask this in an Office Developer forum. The questions here focus on SharePoint search issues.

      #1; Tue, 02 Oct 2007 18:06:00 GMT