Microsoft KB Archive/98607

{| = Contents of README.TXT from Open EIS Pak 1.0 for Windows =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q98607 The information in this article applies to:
 * Microsoft Excel Microsoft Open EIS Pak for Windows, version 1.0
 * Microsoft Excel for Windows, version 4.0 and 4.0a

Summary:

The following is the contents of the Open EIS Pak for Windows README.TXT which is located in the EIS subdirectory after you install the Microsoft Open EIS Pak for Windows. The last section contains information regarding the files needed for the sample applications included in the package.

More Information:

*** Microsoft Open EIS Pak Version 1.0 README File ***
This file contains additional information for the Microsoft Open EIS Pak. The following information is included:


 * Notes on the Microsoft Excel EIS Builder

- Tips and Techniques Examples - Using Online Help - Using International Versions of Microsoft Excel - Halt Tool Changes - Alternate Installation of Run-Time Files - Restoring Minimized Applications While Using DDE - Starting the Sample Applications - Default Directories and Files
 * Files Included With The Microsoft Open EIS Pak

Tips and Techniques Examples
To assist EIS developers with creative design techniques, an additional application has been created. This application may be found in the Examples directory under the Microsoft Excel EIS Builder directory (the default is C:\EISPAK\EISBLDR\EXAMPLES).

This application features online discussion of special techniques used to create the user interface. To get the most benefit out of this application, start by loading the Microsoft Excel EIS Builder (AUTHOR.XLA). Once loaded, open the application by selecting the Open command from the EIS menu, and select XAMPLS.XLA. (Note: The Queries Help topic indicates that the examples XLA file is called EXAMPLES.XLA. The correct file name is XAMPLES.XLA not EXAMPLES.XLA.)

Using Online Help
As you begin using the Microsoft Excel EIS Builder, you should spend a few minutes reviewing EIS Builder Help. Much of the detailed information you need to know on actions, arguments, dialog box options, settings details, and other important topics is readily available through the online Help facility. Whenever the EIS Builder is loaded, Help may be accessed by choosing the EIS Builder Help command from the Microsoft Excel Help menu. If you want to access context-sensitive information for a specific dialog box, click the Help button in that dialog box.

For step-by-step instructions on using EIS Builder Help, see &quot;Before You Begin&quot; in the Microsoft Excel EIS Builder User's Guide.

Using International Versions of Microsoft Excel
The version of the Microsoft Excel EIS Builder contained on these diskettes will not work with international versions of Microsoft Excel. If you wish to use the Microsoft Excel EIS Builder with a version of Microsoft Excel other than English, please contact your local Microsoft subsidiary.

Like the Microsoft Excel EIS Builder, the sample applications contained on these diskettes also require the English language version of Microsoft Excel.

Halt Tool Changes
When you are creating an application with the Microsoft Excel EIS Builder, you may wish to test the application using the Run command on the EIS Menu. When the application is being run from within &quot;author mode,&quot; a single icon appears on a Halt tool bar in the upper left corner of the window. By clicking on this icon, the application being run halts and you are returned to author mode.

If the application being run uses the standard Excel menu, the developer may also return to author mode by choosing the Halt command from the EIS Menu. The application will then be halted, and the Halt command will change back to the original Run command.

Should you wish to hide the toolbar, it may be hidden by clicking in the upper left corner of the toolbar. In order to return to author mode, you must either select the EIS Halt command, or enter Ctrl-H.

Alternate Installation of the Run-Time Files
The Microsoft EIS Builder utilizes three run-time files. These files may be freely copied to users who do not have a licensed copy of the Microsoft Excel EIS Builder. Such users, however, will require a licensed copy of Microsoft Excel.

These files are:

Filename     Definition ---

EIS.XLA      The main EIS macro

XTACTION.XLA The dialog box and functions for crosstab tables on EIS Views

EISUSER.HLP  The Windows Help file for users of an                application built with the Microsoft Excel EIS Builder By default, the Microsoft Open EIS Pak Setup program installs these files in the C:\EISPAK\EISBLDR directory. The Setup program also installs EIS.XLA and EISUSER.XLA in the directories used by the EIS Limited sample application (C:\EISPAK\SAMPLES\EISLTD) and the Tips and Techniques Example application (C:\EISPAK\EISBLDR\EXAMPLES). If instead you wish to have a single copy of these files on your hard disk, they may be copied to your Excel Library directory (typically C:\EXCEL\LIBRARY) and deleted from other locations. Files may be copied using a DOS COPY command or the Windows File Manager. Whenever a user's EIS application files is opened and these run-time files are not present in the same directory, the application will automatically look in the Excel Library directory for these files.

Moving or Deleting Files
Should you wish to delete or &quot;uninstall&quot; any of the Open EIS Pak applications, the files may simply be deleted. The Open EIS Pak files do not require any changes to *.INI files, however, deletion of files may result in your being unable to run the software. If this occurs, simply reinstall the software using the setup program on your diskettes.

Should you wish to move any of the Open EIS Pak files to another location, they may be copied provided that all files in old directories remain together in the new directories, and that the new directories adhere to the structure noted in the default file directory listings later in this document. The only exception to this pertains to the Run-Time files, described above.

Restoring A Minimized Application While Using DDE Links
To use a Perform DDE action, you must activate the application in which the action is being performed, and restore the application if it is minimized. The Activate Application action in the Inter-application action class should be used to activate the application.

The commands needed to restore an application vary between applications. In general, use a Perform DDE action which contains the keystrokes necessary to restore the application. For many windows applications, an operation of % r (equivalent to Alt - space - r) can be used.

*** Files Included with The Microsoft Open EIS Pak ****
When you run Setup from the Setup disk, all the files you need to run the sample applications and the Microsoft Excel EIS Builder are copied.

To save space on the disks, many files shipped with Microsoft Open EIS Pak are compressed. Compressed files are identified by a &quot;_&quot; in the file extension. These files cannot be used directly with Microsoft Windows or Microsoft applications; they must be decompressed before use. When you run Setup from the Setup disk, these files are automatically decompressed.

Starting the Sample Applications
The Microsoft Open EIS Pak diskettes contain four sample EIS applications. A set of application profiles is included in the Pak. These profiles provide important information on the design considerations and unique aspects of each demo, as well as start-up information. All of these sample applications require Microsoft Excel 4.0 or later. In order to ensure that the sample applications work properly, check to see that the directory containing Microsoft Excel is included in your DOS path. The DOS path is typically included in the AUTOEXEC.BAT file. If you are using Microsoft Word for Windows or Microsoft Project for Windows, the subdirectories containing these applications also need to be included in the DOS path.

To Start           Open File

EIS Builder        ..\EISPAK\EISBLDR\AUTHOR.XLA

EIS LTD Demo       ..\EISPAK\SAMPLES\EISLTD\EIS_DEMO.XLA

Hydromax           ..\EISPAK\SAMPLES\HYDROMAX\HYDROMAX.XLA

Otis CFO           ..\EISPAK\SAMPLES\OTISCFO\EISDEMO.XLA

ControlPoint       ..\EISPAK\SAMPLES\CNTRLPNT\CTRLPNT.EXE

List of Microsoft Open EIS Pak Files
The following table lists all Microsoft Open EIS Pak files on the disks in the Microsoft Open EIS package. Files are grouped by directory. File distribution is the same for both disk configurations (1.44M, 1.2M).

Microsoft Excel EIS Builder Files
Default Directory: C:\EISPAK\EISBLDR

Decompressed Files
APP.XLA AUTHOR.XLA BUTTONS.XLA CELLDEF.XLA EIS.XLA EISAUTH.HLP EISUSER.HLP MENU.XLA XTAB.XLA XTACTION.XLA

Microsoft Excel EIS Builder Tutorial Files (See chapter 2 of the Microsoft Excel EIS Builder User's Guide)

Default Directory: C:\EISPAK\EISBLDR

Decompressed Files

DCHARTS .XLS DCROSTAB.XLS DDATA .XLS DSPLASH .XLS

Microsoft Excel EIS Builder Tips & Techniques Example Files

Default Directory: C:\EISPAK\EISBLDR\EXAMPLES

Decompressed Files
EIS.XLA EISUSER.HLP EMP.DBF XAMPLS.XLA XMP_CELL.XLS XMP_DDE.XLS XMP_DOC .DOC XMP_EDIT.XLS XMP_HIDE.XLS XMP_HOME.XLS XMP_KEY.XLS XMP_OUTL.XLS XMP_Q1.XLS XMP_Q2.XLS XMP_Q3.XLS XMP_STOP.XLS XMP_TIME.XLS

Microsoft ControlPoint Sample Application Files

Default Directory: C:\EISPAK\SAMPLES\CNTRLPNT

Note: ControlPoint will fail unless Microsoft Excel 4.0 is properly installed and included in the DOS path.

Decompressed Files

BLDSL.EXE CP_CHART XLM CP_CHART.XLS CTOHWND.DLL CTRLPNT INI CTRLPNT IVF CTRLPNT.EXE CTRLPNT.HLP SELIST.DAT

Microsoft ControlPoint Sample Application Database Files

Default Directory: C:\EISPAK\SAMPLES\CNTRLPNT\EISDB

Note: These files must reside in the EISDB directory under the directory containing CTRLPNT.EXE.

Decompressed Files
CP_CHNL.XLS CP_GEO.XLS CP_MEAS.XLS CP_ORG.XLS CP_PERSP.XLS CP_PROD.XLS CP_TIME.XLS TESTDATA.XLS

Additional Microsoft ControlPoint Sample Application Files

Default Directory: C:\WINDOWS\SYSTEM

Note: These files must reside in the default Windows System directory.

Decompressed Files
GRID.VBX MDICHILD.VBX PICCLIP.VBX QELIB.DLL QEUTIL.DLL QLXLS.DLL SPIN.VBX THREED.VBX VBRUN100.DLL

English International Savouries Sample Application Files

Default Directory: C:\EISPAK\SAMPLES\EISLTD

Decompressed Files
EIS.XLA EIS_DEMO.XLA EISUSER.HLP FLASH.XLS GRID.VBX HOME.XLS INTRO.XLS LEX.XLS MAIL_BIT.XLS MAP.XLS PRODSYS.EXE PROJ_BIT.XLS PROJECT.XLS REPORT.DOC STATUS.XLL SUMMARY.XLS THREED.VBX TREND.XLS

Hydromax Sample Application Files
Default Directory: C:\EISPAK\SAMPLES\HYRDROMAX

Decompressed Files
4-TIERS.MPW B&W.XLS CALENDAR.MPC COLOR.XLS EIS.MPP EIS.MPW EIS.XLS FILEFNS.DLL FLOATS.MPP HYDROMAX.XLA LOB.XLS MFG-ASY.XLS PROJECT1.MPP SALE-FUN.MPP SALESFUN.MPV SEAPLANE.MPP TESTFIXT.MPP VIEW.MPV

Otis CFO Sample Application Files
Default Directory: C:\EISPAK\SAMPLES\OTISCFO

Decompressed Files
CFO.INI CFO.XLA CFOHELP.XLS CONTROL.XLS DRILLDWN.XLT EISDEMO.XLA EISINTRO.XLS EXEC_1.XLS EXEC_2.XLS EXEC_3.XLS EXEC_4.XLS EXEC_5.XLS INTRO.XLS MAINMENU.XLM PCMENU.XLM REGION.PLS SDMENU.XLM SHEET1.XLS

Otis CFO Sample Application Miscellaneous Files
Default Directory: C:\EISPAK\SAMPLES\OTISCFO\PER04

Note: These files must reside in the PER04 directory under the EISDEMO.XLA file.

Decompressed Files
CCB_09_2.P04 CCB_12_2.P04 CCB_15_2.P04 CCB_27_2.P04 CCB_33_2.P04 CCB_42_2.P04 CCB_45_2.P04 S01-PETC.P04 S01-PLAC.P04 S01-PNAC.P04 S01-PPAC.P04 S01-PTOC.P04 S02-PETC.P04 S02-PLAC.P04 S02-PNAC.P04 S02-PPAC.P04 S02-PTOC.P04 S03-PETC.P04 S03-PLAC.P04 S03-PNAC.P04 S03-PPAC.P04 S03-PTOC.P04 S04-PETC.P04 S04-PLAC.P04 S04-PNAC.P04 S04-PPAC.P04 S04-PTOC.P04 S05-PETC.P04 S05-PLAC.P04 S05-PNAC.P04 S05-PPAC.P04 S05-PTOC.P04 S06-PETC.P04 S06-PLAC.P04 S06-PNAC.P04 S06-PPAC.P04 S06-PTOC.P04 S07-PETC.P04 S07-PLAC.P04 S07-PNAC.P04 S07-PPAC.P04 S07-PTOC.P04 S08-PETC.P04 S08-PLAC.P04 S08-PNAC.P04 S08-PPAC.P04 S08-PTOC.P04
 * }