DDE Link formatting
 

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.

DDE Link formatting
 

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




"ORLANDO V" wrote in message
...
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.

DDE Link formatting
 

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

On Thu, 13 Dec 2007 13:55:01 -0800, ORLANDO V
wrote:

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.

DDE Link formatting
 

Thanks.

"ORLANDO V" wrote:

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.

DDE Link formatting
 

Thank you.

"ORLANDO V" wrote:

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.