DDE parameters and EXCEL
Posted on 1998-06-10
I am using Borland C++ Builder 1.0 to write an application that needs to monitor an Excel spreadshhet. I have coded and tested a DDE server for test purposes to chek my application and it works just fine until I try to monitor the microsoft excel spreadsheet.
The problem is that I can't find anywhere that tells you how microsoft names the DDE conversation and DDE item parameters for an EXCEL spreadsheet ?
I am using the following which doesn't work for a workbook named Book1.xls with a spreadsheet called Sheet1 and referencing cell A1 :-
DDE Service : EXCEL
DDE Topic : Book1
DDE Item : Sheet1!A1
Can anyone please help ?