Using a cell reference within a DDE link formula
Posted by Bill Nagel on February 09, 2001 6:19 AM
Any advice would be greatly appreciated.
I am trying to use a cell reference within a DDE link formula that I have created.
As an example, my link formula is
where 15723 is a specific work order number.
I would like use a cell reference rather than the work order number,
for example '\\($B$1)\($B$1)_calcs\[$B$1_calcs_26wk_adj......), such that I can run
this query without having to update it for each cell on the network that I
am trying to link to.
Is this just a matter of using the correct syntax?