Kbase P43140: Error 2570 firing COM Object event procedures for Microsoft Excel.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/19/2010 |
|
Status: Verified
SYMPTOM(s):
Error 2570 firing COM Object event procedures for Microsoft Excel.
Procedure <proc> sent sub-procedure <proc> mismatched parameters. (2570)
FACT(s) (Environment):
Enabled event notification for the Excel Automation Object via ENABLE-EVENTS Method.
Attempting to execute a couple of different COM Object event procedures for the Excel's Workbook sub-object such as WorkbookBeforePrint, WorkbookBeforeSave and WorkbookBeforeClose.
Accessing an Excel Spreadsheet from Progress 4GL using ActiveX Programming.
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
The problem occurs because the automation object uses named parameters for events. Progress does not fully support named parameters which can cause parameters to be returned in a different order than what the ABL expects.
CAUSE:
Bug# OE00095203
FIX:
Workaround:
Reverse the order of the event parameters.
Note that any INPUT-OUTPUT or OUTPUT parameters may not function correctly for the OUTPUT aspect, this is another issue related to the parameter ordering.