Exact Financials

How to instal Excel add-in using ODBC (Until version 7.12)

Before you install Exact Excel Add-in, Excel has to be installed together with the Data Access Objects (DAO) functionality:

For installing Exact Excel Add-in please follow the steps mentioned below:

1. Start Windows. Close all programs in use (mind that Excel is closed too)
2. Put the CD-ROM containing the Excel Add-in installation in your CDROM-drive.
3. Choose [Start, Run] in Windows.
4. Use the 'Browse' button and select the file 'Setup-ExcelAddIn.exe' on the CD or type the following command directly: "D:\Setup-ExcelAddIn.exe" (Provided CDROM-drive is mapped to D:\) and click 'OK'.

The Excel Add-In functionality of Exact Financials can be found in the file called 'exactcs.xla'. The following procedure installs the Add-In functionality on a client.

Manually

• On your client, copy the file called 'exactcs.xla' to the subdirectory XLSTART within your Excel directory.

After you have carried out the steps mentioned, you can start up the Excel Add-In. The menu bar contains an extra menu-option: 'Exact Financials', at the top-right.

Under 'Exact Financials' you will find the following menu options:

When the option 'Login Database' is chosen, a screen appears containing several buttons. The first three buttons can be used to choose the default connection settings of Progress / Oracle. The button 'Customize ODBC Driver' can be used to define the settings yourself. This can be necessary when you use non-standard ODBC drivers or when 'progress' is not the owner of the Exact tables on an Oracle database.

In this chapter a few general tips are given for working with Exact Excel Add-In. They mainly concern with the functions with which you can use data from Exact in your worksheet. The functions are explained separately in chapter 3. Furthermore, the settings per worksheet are explained, for example, the search for codes and descriptions of master data in Exact. Finally, an explanation is given on quickly generating an overview with data from Exact, with the help of a wizard.

See also:
How to install Progress OpenEdge ODBC drivers on a workstation