Micromod Micro-PWC: 53PW6000 MicroPWC Installation and Setup Manual - Manual (Page 49)

Micro-PWC
™ Installation & Setup Guide
Installation 39
2. In the System Properties window that appears, click on the Environment tab.
3. In the System Variables field, scroll down to the PATH variable and select it. The PATH
variable and its associated value will be displayed in text entry boxes (labeled Variable and
Value) at the bottom of the window.
4. In the Value text entry box, edit the value to include the path of the Excel Executable. Typically
this means adding one of the following directories to this PATH: \msoffice\excel or
\excel
. Be sure to include the drive specification as well as the directory (e.g.,
c:\microsoft\excel ).
3.5.3.1 Add-in Functions for Microsoft Excel
A number of special functions, sometimes referred to as "add-ins", have been developed to provide the
Micro-PWC system interface to Microsoft Excel.
The add-in functions are contained in the file FPEXCEL.XLA. This file is located in the bin directory for the
Micro-PWC system software; i.e., <installation directory>\bin. Typically, this is:
C:\MICROPWC\BIN
In order to make the add-in functions available to Excel, perform the following operations:
1. Start Microsoft Excel.
2. Click on the Tools item on the menu bar of the Excel spreadsheet, then click on
Add-Ins... on the resulting menu. The Add-Ins dialog box will appear.
3. In the Add-Ins dialog box, click on the Browse... button, which will cause the Browse dialog
box to appear.
4. The Browse dialog box contains two scrollable list boxes labelled File Name and Directories.
In the Directories list box, locate the entry for the bin directory of the Micro-PWC system
installation. Click on this entry to select it.
5. In the File Name list box, the file name FPEXCEL.XLA will appear. Click on FPEXCEL.XLA to
select it, then click on the Ok button. This will exit the Browse window and return to the
Add-Ins window.
6. A list box labelled Add-Ins Available is located in the Add-Ins window. Locate the entry which
reads Fpexcel. Click in the square next to this item to select it, then click on the Ok button.
The function will now be available for use.
Once installed, the add-in functions can be accessed using either of the following methods:
1. Click on a cell to select it, then type in the function.
2. Alternatively, use the Function Wizard for Excel. In the Function Wizard, the add-in functions
can be found under the User Defined Function category. (To access the Excel Function
Wizard, select the sequence Insert > Function from the menu bar of the Excel spreadsheet.
See your Microsoft Excel documentation if you have questions about the Function Wizard for
Excel.)
3.5.3.2 Printing Microsoft Excel Spreadsheets
Printing and scheduling of Excel spreadsheets through the Micro-PWC system is supported, provided that
a valid printer name is selected for use. A valid printer name is one that was configured using the Windows
Printer utility. Valid printer names for use with Excel spreadsheets may be determined as follows:
Navigate to the Control Panel and select Printers. Printers that have been configured in Windows appear
in a list format or as icons in this window. When attempting to print or schedule printing of an Excel spread-
sheet, be sure to use one of the printer names found in this list. (Information on how to initiate log printing