Hi, I need to track updates from a DDE server. The cells get values for each stock by this formula:
where STOCK is a particular stock.
As Worksheet_Change does not capture changes from DDE, I tried doing this on load:
and then I try:
The problem is that Excel raises Error 424 - Object required... I suspect SetLinkOnData does not pass Application.Caller data. If this is correct, how could I get the cell that had its value updated?
Code:
=FTW_OPUB|'FW_OPUB:m_CURRENCY'!'STOCK'As Worksheet_Change does not capture changes from DDE, I tried doing this on load:
Code:
ActiveWorkbook.SetLinkOnData "FTW_OPUB|'FW_OPUB:m_CURRENCY'!", "Test"and then I try:
Code:
Sub Test()
Debug.Print Application.Caller.Address
End SubThe problem is that Excel raises Error 424 - Object required... I suspect SetLinkOnData does not pass Application.Caller data. If this is correct, how could I get the cell that had its value updated?