Consultor Eletrônico



Kbase 21409: Error: DDE failed. (3153)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/16/2008
Status: Verified

FACT(s) (Environment):

Microsoft Excel 2000 Spanish Edition

SYMPTOM(s):

Error: DDE <type> failed. (3153)

CAUSE:

This error stands for "data not accepted". When you are using DDE SEND, you also need to define the ITEM like so: DDE SEND sheet SOURCE "Name" "R1C1".

In an English version, this ITEM could be called "R1C1" (row 1 column 1).

FIX:

If you need to find out what sheet row and column in other languages, follow these steps:

1) Open a new sheet in Excel.

2) Change to R1C1 Reference Style (Tools > Options > General > Setting
and select R1C1 reference style)

3) Type something on Sheet 1, R1C1 and copy the cell content.

4) Turn to Sheet 2 and select any row and column.

5) Right click to do Paste Special.

6) Select Paste Link button.

Immediately, you should see "=Sheet1!R1C1" in the formula cell above.

To do this in other languages, you should be able to find out
what is sheet, row and column in that language.