Beratung und Entwicklung - Mehr Produktivität für Microsoft Office
Consultant and Developer - Get more productivity from Microsoft Office
Kontakt
domke consulting
Falltorweg 6
D-63303 Dreieich
Telefon: +49 6103 596 69 47
Telefax: +49 6103 596 69 58
Mail: info@domke-consulting.com
Word: Add-in for client-related print output
Request: In a Call Center users need to create autotext-based documents which must be printed on the stationery of the current client. Printers with multiple paper trays are already installed, but the users must select the printer and the appropriate tray manually, which costs time and is error-prone, because the relation between printer / tray and client is not transparent.
Solution: An global Add-in is provided. In administrative mode the relation between printer tray and client stationery is defined. On startup the VBA program reads the configuration file and sets up a commandbar, on which menu entries show the client name. Printout of a document to the correct stationery is a two-click affair.
Comment: Small footprint, little development costs (2,5 days), big return on investment for the whole call-center.
Powerpoint 2003: Company-specific File-New-Dialog
Request: During the migration from Office 97 to Office 2003 the QA department notices that the FileNew dialog has been replaced by the Task Pane "New document". The company templates are not immediately shown, but need a drill-down to the "Templates from my computer" item on the Task Pane.
However, users should have immediate access to the company templates. Users shall not see the Microsoft Template Catalog, but immediately the company-specific templates.
Solution: Powerpoint does not provide the functionality to load an Add-iIn file on startup and execute a program. So a COM Add-in developed with Visual Basic is provided. Registry settings under "Local Machine" assure that the Add-in is loaded for every user. The FileNew command is replaced by a custom dialog, which shows the Powerpoint templates of the company and it's branches in layout preview.
The dialog is configured through a XML configuration file on startup, so that administrators can add new tabs and new templates in the dialog without need to recurr to the developer.
