concatenating with a DDE link?
Posted by Myles on August 01, 2001 10:42 AM
I would like to create a formula which inserts a value from a given cell into a working DDE link formula, along the lines of:
"=abDDE|BAR!'" & A1 & ";LEVEL'"
where A1 contains a symbol. For example if cell A1 contains the value "ART" then I need something that results in the creation of a working DDE link:
Is this possible? I've got to do 40-50 of these on a daily basis and I'm pulling my hair out trying to automate this.