Kbase P76681: DDE ERROR 10 when reading data from Excel field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Excel 2000 (German)
Windows XP
Progress 9.1D
SYMPTOM(s):
DDE ERROR 10 when reading data from Excel field
CAUSE:
Reading data with the following command:
DDE REQUEST ....... ITEM "R3C1" NO-ERROR.
returns DDE ERROR 10, because the German version of MS Excel uses 'Z' and 'S' to identify the columns and rows.
FIX:
change the line to:
DDE REQUEST .... ITEM "Z3S1" NO_ERROR.