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?
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)
Leave a comment...
- 1 Comments
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