Excel and PowerPoint programming of a corporate design tool

Development of Office add-ins and Office templates

ams AG (Unterpremstätten / Austria), a multinational semiconductor manufacturer, commissioned eWorks as Microsoft Office experts to create several Office templates and develop two add-ins for Microsoft Excel and PowerPoint. The objective was to program Microsoft Office add-ins for the fast and convenient creation of Microsoft PowerPoint presentations and Excel workbooks in the client's corporate design.

The graphic template design was carried out by the client themselves and was provided to eWorks in the form of a visual template that represented the corporate design in terms of colors, fonts, formatting, positioning and other design features. Based on this, eWorks developed both a Microsoft Excel template and a PowerPoint template, which were fine-tuned in close consultation with the client until they finally met all the requirements.

The PowerPoint and Excel add-ins were then developed using macro programming with VBA (Visual Basic for Applications). These Microsoft Office add-ins offer individual functionalities for creating Excel tables and PowerPoint presentations, e.g. quick insert buttons for quickly inserting and designing tables, diagrams and other content in the company colors. These Microsoft Office enhancements were rounded off with an automatic language switch, which switches the language of the current Excel spreadsheet or PowerPoint presentation between German and English at the click of a mouse.

eWorks supported its client in the implementation of the two Microsoft Office extensions right from the start of the project: from planning, template creation, Excel programming and PowerPoint programming through to the handover and acceptance of the completed PowerPoint and Excel extensions. Following the installation, eWorks is available to its client as a Microsoft Office service provider for operating questions, any error reports (warranty) and possible extension requests for the Office add-ins.