Microsoft KB Archive/98606

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

Last reviewed: September 12, 1996

Article ID: Q98606 The information in this article applies to:
 * Microsoft Excel Microsoft Open EIS Pak for Windows, version 1.0a
 * 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 Microsoft Open EIS Pak for Windows. Section K contains information regarding development of EIS Applications both for the Apple Macintosh and the Microsoft Windows environments.

Note that this article reflects the text of a static document. Therefore, some of the information in this article may be outdated. For example, as of May 20, 1996, Microsoft no longer maintains support forums on CompuServe.

MORE INFORMATION

 * Microsoft Open EIS Pak Version 1.0 README File ***

>>>  For proper display of this file with the Windows Notepad  <<< >>> select the Edit menu and then choose the Word Wrap command. <<< This file contains additional information for the Microsoft Open EIS Pak. The following information is included:

- Notes on the Microsoft Excel EIS Builder

A - Tips and Techniques Examples B - Using Online Help C - Using the CompuServe Forum D - Installing the Open EIS Pak With A Network Copy of Microsoft Excel E - Using International Versions of Microsoft Excel F - FILEFNS Files G - Halt Tool Changes H - Alternate Installation of Run-Time Files I - Moving or Deleting Files J - Restoring Minimized Applications While Using DDE K - Creating EIS Applications for Both Apple Macintosh &

Microsoft Windows Users
  Files Included With The Microsoft Open EIS Pak L - Starting the Sample Applications M - Default Directories and Files 


 * Notes on the Microsoft Excel EIS Builder ***

A - 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.

B - 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.

C - Using the CompuServe Forum
If you wish to request support from Microsoft Product Support Services or share ideas with other users, a CompuServe Forum is available. The forum provides a vehicle for users to share ideas and sample applications. To use the forum, go to the Microsoft Excel forum, where you will have access to the EIS Pak section. For more information on the Microsoft Compuserve forum, see &quot;Product Support Services&quot; in either the Microsoft Excel EIS Builder User's Guide, or in Microsoft Excel EIS Builder Help.

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.

D - Installing the Open EIS Pak With A Network Copy of Microsoft Excel
Although the Microsoft Open EIS Pak can be used with a network resident copy of Microsoft Excel, the SETUP program will not recognize a copy of Microsoft Excel on the network. To install the Open EIS Pak when your EXCEL.EXE is on a network:


 * 1) Create an EXCEL directory on your local hard disk.
 * 2) Using either the MS-DOS COPY command or the Windows file manager, copy the EXCEL.EXE file to your local EXCEL directory.
 * 3) When the Open EIS Pak setup program prompts you for the location of your copy of Microsoft Excel 4.0, enter C:\EXCEL (or the location of your EXCEL.EXE file copied in step 2 above).
 * 4) After completing installation of the Open EIS Pak, delete the local copy of EXCEL.EXE.

E - 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.

F - FILEFNS files
The Microsoft Excel Builder requires two optionally installed Microsoft Excel files. Although these files are typically installed with the full Microsoft Excel 4.0 setup, if you have used a custom setup option, they may not have been installed. If either FILEFNS.XLA or FILEFNS.DLL is not present in your EXCEL\LIBRARY directory, they must be installed prior to using the Microsoft Excel EIS Builder. To manually install the files:


 * 1) Insert the Microsoft Open EIS Pak diskette #2 into your diskette drive.
 * 2) Using either the MS-DOS COPY command or the Windows File Manager, copy the files to your EXCEL\LIBRARY directory.
 * 3) If Excel is running, you will need to exit Microsoft Excel and restart the program in order for these files to be recognized.

G - 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.

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:

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 an MS-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.

I - 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.

J - 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.

K - Creating EIS Applications For

Both Apple Macintosh and Microsoft Windows Users The Microsoft Excel EIS Builder is designed to enable authors to easily port applications between the Microsoft Windows and Apple Macintosh platforms. This is accomplished through the use of a common application macro file format (APP.XLA), and the cross-platform design of the EIS Builder run-time files (EIS.XLA & XTACTION.XLA). By using MS-DOS 8.3 file names, the EIS Builder links are automatically preserved when porting applications between platforms.

The following issues should be considered when developing EIS applications to be used by both Apple Macintosh and Microsoft Windows users.

1-EIS Builder and Run-Time Files

EIS authors who intend to deploy a single application across both Apple Macintosh and Microsoft Windows platforms should have a copy of the Microsoft Open EIS Pak for Windows and the Microsoft Open EIS Pak for the Macintosh. Authors may use either set of EIS Builder files, however, end-users should use the run-time files for their Microsoft Excel platform.

2-Path and File Names

In order to eliminate the need to maintain separate files whose links are updated manually, authors deploying cross-platform applications should adhere to a common set of MS-DOS 8.3 filenames. This file naming convention will be valid in both the Apple Macintosh and Microsoft Windows environments. Although these environments use different path separator characters (&quot;:&quot; on the Macintosh, and &quot;\&quot; under Windows), the EIS.XLA macros will automatically use the character appropriate for the version of Microsoft Excel being run. As with file names, authors should take care to use a common folder/directory naming scheme. For example, the following EIS application macro file could be run in both environments:

Apple Macintosh: Finance:EIS:FinEIS.XLA Microsoft Windows: FINANCE\EIS\FINEIS.XLA 3-Using The EIS.GETPLATFORM Function When deploying cross-platform applications, authors are face differences in bitmap formats, DDE syntax, and query facilities. Because the Microsoft Excel EIS Builder enables authors to run scripts based upon a condition, the following custom function macro has been added to the EIS.XLA file:

EIS.GETPLATFORM This function returns &quot;Mac&quot; when Microsoft Excel for the Macintosh is running, and &quot;Win&quot; when Microsoft Excel for Windows is running. By using this function in a conditional expression, authors can develop and distribute a common set of files that automatically evaluate the user's platform and run the appropriate script.

For example, the author could create the following two named scripts to produce a query of sales data:

&quot;Query Sales (Mac)&quot; &quot;Query Sales (Win)&quot; A single &quot;Get Sales Data&quot; button on a user's view could then run the following script: IF    THEN Run Named Script: Query Sales (Mac) ELSE Run Named Script: Query Sales (Win) ENDIF By using the following condition for the IF statement, this script would automatically support both Macintosh and Windows users: EIS.GETPLATFORM = &quot;Mac&quot; For more information on the use of conditional expressions, search for the keyword &quot;condition&quot; in the Microsoft Excel EIS Builder help facility. 4-Use of Bitmaps

Authors deploying cross-platform applications should avoid the use of bitmap objects, since these will not port cleanly between the Apple Macintosh and Microsoft Windows environments. In such applications, it is recommended that end- user functionality be implemented using custom menus rather than on-sheet pictures. If on-sheet buttons are used, authors should limit their use to those which are not bitmaps. The non-bitmap buttons are:

Macintosh Buttons  Equivalent Windows Buttons --

MS Excel Button    3-D Button Stick-It-Note      Stick-It-Note Text Box           Text Box Transparent Button Transparent Button 3-D Cell Overlay   3-D Cell Overlay Another alternative is to have the script display a different view, depending upon the platform being used. In this case, the author would create a Mac version of the view worksheet(with Mac bitmaps), and a Windows version of the worksheet (with Win bitmaps). By using a condition to determine which view to display, a single application can easily support both Macintosh and Windows users. For more information, see the &quot;Using The EIS.GETPLATFORM Function&quot; section above. 5-Reassigning EIS Macros To New Bitmaps

If bitmaps with script actions are used, the author may wish to paste new bitmaps into a ported file. When this is done, any macro scripts assigned to the original bitmap must be manually reassigned to the new bitmap. The easiest procedure for reassigning bitmap scripts is:


 * 1) Port the Excel worksheet from the Macintosh to Windows or vice versa.
 * 2) Open the worksheet file containing a bitmap
 * 3) Paste a new bitmap onto the sheet.
 * 4) Select the original bitmap object (on the Macintosh use Command-Click; in Windows use CTRL-Left Click)
 * 5) From the Excel Macro Menu, select the Assign To Object Command, and then choose the OK button.
 * 6) Select the new bitmap object
 * 7) From the Excel Edit Menu, select the Repeat Assign To Object Command.

The above sequence of steps will automatically assign the old bitmap macro script to the new bitmap. At this point, the author should reselect and delete the old bitmap. 6-DDE Script Actions

DDE script action arguments vary between the Apple Macintosh and Microsoft Windows environments. Consider the following two &quot;Initiate DDE Channel&quot; script arguments to open a Microsoft Word Document:

Document Type       Document Name --

Apple Macintosh: WordDocument   TESTFILE.DOC Microsoft Windows: WINWORD   TESTFILE.DOC For more information on DDE script action arguments, look up &quot;DDE&quot; in your product documentation index. Although DDE syntax differs on these two platforms, it is possible to execute the DDE calls conditionally (according to the platform on which the DDE script is running). For more information, see the &quot;Using The EIS.GETPLATFORM Function&quot; section above.

7-External Database Queries

On the Apple Macintosh, Microsoft Excel supports the Apple Data Access Language (DAL) for external database queries. This support requires installation of the Data Access Macro (DAM) option with your copy of Microsoft Excel.

Under Microsoft Windows, external database query support is accomplished with Q+E. This support requires installation of the Q+E driver option with your copy of Microsoft Excel.

Regardless of whether the Apple Macintosh or Microsoft Windows environment is being run, the Microsoft Excel EIS Builder relies upon a common query statement stored on a worksheet. This query is stored in a named range called &quot;SQL_Statement&quot;. Due to the environmental differences between the Data Access Language and Q+E, EIS authors deploying queries across platforms may not be able to share the same query sheets across platforms. Although the required query scripts differ on these two platforms, it is possible to execute the queries conditionally (according to the platform on which the DDE script is running). For more information, see the &quot;Using The EIS.GETPLATFORM Function&quot; section above.


 * 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.

L - 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.

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 Note: *Only* the EIS LTD Demo application uses the Microsoft Excel EIS Builder. The other applications are included as additional examples of EIS solutions based on Microsoft products. To use the other three applications, be sure to follow the above instructions, or those printed on the Sample Application Profiles included in the Open EIS Pak.

M - 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 1.0a 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 &quot;User's Guide&quot;)

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 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

Files Not Installed by the Open EIS Pak Setup Program
The following uncompressed files are included on Disk 2:

FILEFNS.DLL FILEFNS.XLA EISPAK.ICO Although the FILEFNS files are typically included in a full installation of Microsoft Excel 4.0, they may not be present on your system. Both of these files must be present in your EXCEL\LIBRARY directory *prior* to using the Microsoft Excel EIS Builder. To install the files, simply use the MS-DOS COPY command or the Windows File Manager to copy the files to your EXCEL\LIBRARY directory. The EISPAK.ICO file may be used to represent either the Microsoft Excel EIS Builder or the sample applications as part of a Windows Program Manager group. For help on specifying Program Manager icon, see either &quot;Icons&quot; or &quot;Program-item Icons&quot; in the index of your Microsoft Windows User's Guide.
 * }