How do I change advanced "Printing Preference" for Microsoft Office Document Image Writer programmatically?
Posted on 2008-10-17
Hi there. I'm looking for a solution to change the advanced printing preferences for the Microsoft Office Document Image Writer programmatically. The default file output format is "MDI". I need to change it to "TIFF" without user intervention. Once changed, the default can stay as tiff. There is no need to change it back.
I'm currently using the printout command in VBA to create a file in tif format. Unfortunately, although it's extension is a tif, it is still an MDI format. I can get around this by first changing the advanced printing preferences manually first. Then it properly prints it out as a tif.
I've tried using the MODI object with VBA but no luck. Any ideas either using a batch file or VBA that I could then asks users to run? Problem is I cannot change the registry keys directly as I do not have administrator access.