formula using cell reference returns no value

D

dmcfender

Using DDE I'm trying to pull data from an application running on anothe
machine. Everything works fine when I type the whole pat
\\computer\application|topic!'item'. The item is on the sheet
and every item is different and a lot of them. I did manage to get th
formula to show up correctly in the cell where I want to display th
value. I would like the value to show.

Formula bar = "\\computer\application|topic!"'" & (a1) & "'" this is
close but I did it at work today. Thank
 
Top