question

Upvotes
Accepted
1 0 1 1

Can i use cell references in DDE links? example: =REDILink|'L1'!'SPY;Lp'. is there a way to reference a cell for the symbol instead of needing SPY hard coded in the formula?

redi-apieikon-for-office
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
28.3k 30 11 15

Hello @dwilson3,

Yes, it can be done. To be clear, the tweak is not REDI-specific, and is not elegant, but can be used to insert a cell value into any DDE link, review this Tip On Evaluate via Module to create Module with Eval() code.

Now you can modify DDE example:

1. Create the module with Eval, as shown.

2. Cell B5 contains IBM

3.

C17 contains '=RediLink|'L1'!'

C18 cintains ;LP'

D17 contains =CONCAT(C17,B5,C18)

D18 contains =Eval(D17)

And D18 will ultimately contain your last price, such as:

Let us know if this was of help.



1584480627842.png (48.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.