- literal specifications
for Application, Workbook, etc. objects for Excel 97 generated from the
OLEDispatchAnalyzer methods as shown in the file OLEcntrlr.txt in the section
"Building selected specifications from a type library" and for Constants
in section "Building a constants
dictionary".
- a revision to accessor method #workbooks since this is now an Excel property not a method in Excel 97.
- a revision to #getRangeDispatcher: since the Range dispatch interface is obtained as a property and not a method in Excel 97.
- revised clsidApplication and libidApplication GUID values for Excel 97.
- revised sample class methods that use OLEExcel97ControllerSample. In #sampleExcelControllerSession2Expressions the DataType xlFixedWidth is no longer a constant in Excel 97 so the line using this constant is commented out to use the default (which is fixed width after all).
| Excel97Auto.sll | OLEExcel97 class library (source included). |
| volsa3cw.sll (3.1.2) or
volsa3dw.sll (3.1.3) |
OLE Automation Controller Sample |
| Vreg31w.sll | Registration Database Support |
| VOLDB31W.sll | OLE COM Development |
| VOLEB3CW.sll | OLE COM Support |
| VOLEA3CW.sll
volea31w.sll |
OLE Automation Support |
| VOLDA31W.sll
VOLDA3CW.sll |
OLE Automation Development |
It is also recommended that you include the library to the Service Manager by adding the following code to the vsrvw.ini file in your VSE development directory:
[OLE Excel 97 Automation Sample]
description=Excel 97 OLE Automation Controller
category=Samples
libraryNames=excel97auto
requiredServices=OLE Automation Controller Sample
mapCategory=gui
postInstallExpression=Transcript cr; nextPutAll: 'To run the Excel
97 Automation Controller samples see'; cr; nextPutAll: 'the sample session
expressions in the class:'; cr; nextPutAll:' OLEExcel97ControllerSample'.
With this added you may install the Excel 97 Automation Sample by selecting it from the samples group of the VSE Service Manager.