Solved

DDE parameters and EXCEL

Posted on 1998-06-10
1
1,797 Views
Last Modified: 2013-12-03
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 ?

Thanks, Roger
0
Comment
Question by:alcindor
1 Comment
 
LVL 6

Accepted Solution

by:
alamo earned 50 total points
ID: 1407467
Use:

DDE Service :       EXCEL
DDE Topic :          Book1:Sheet1

DDE Item :            R1C1

I don't know of a complete reference for this stuff, unfortunately, though they seem to have lots of examples in their Knowledge Base.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article shows a few slightly more advanced techniques for Windows 7 gadget programming, including how to save and restore user settings for your gadget and how to populate the "details" panel that is displayed in the Windows 7 gadget gallery.  …
This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (http://www.experts-exchange.com/A_2172.html), we saw how to put the Delete button back there where it belongs.  "Delete" is …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question