DDE Link formatting

[ORLANDO V]

Can anyone tell me the sytax for a simple link to a cell in another excel
file on the c drive ? Not for visual basic but the formula for a spreadsheet
cell. I used to know it but haven't used it in years.

 

[Conan Kelly]

ORLANDO V,

There is nothing simple about that.

Just open both source and destination files. In the destination file in any
cell, type an equal sign, switch to the source file, pick a cell and hit
enter. Now close the source file and look at the formula in the cell in the
destination file.

HTH,

Conan

 

[Gord Dibben]

Open both workbooks then in target workbook cell enter an = sign.

Switch to source workbook and select a cell then hit ENTER key.


Gord Dibben MS Excel MVP

 

[ORLANDO V]

Thanks.

 

[ORLANDO V]

Thank you.