4. Enhanced Excel Add-On

The Excel add-on is a UBS data extraction tool embedded in Microsoft Office Excel Application to obtain data directly from UBS database. This tool is typically useful for those users required self designed report by using Microsoft Office Excel Application. With security concern, it is equipped with security control by utilizing user id and password maintained in the selected UBS database.

To maximize the usability, the Excel Add-on is designed to populate data by utilizing defined formulas. These formulas are usable with existing build-in Microsoft Office Excel formulas thus user experiences in reporting customization will definitely will definitely be enhance.

Prerequisite

Microsoft Office Excel 2007, Microsoft .NET Framework 2.0, Language for non-Unicode programs must be set to ‘English’.

Installation & Setup Guide

The Excel Add-On is included in the UBS installer. It would be available automatically by opening MS excel application, after installation of UBS Accounting System or UBS Inventory and Billing System.