Dear List Member,

We are trying to reading certain cells(e.g.R1C1) of the Excel file (ddetest.xls) in a Visual basic application's Textbox through DDE. I have defined the LinkTopic as Excel |Sheet1 and LinkItem as R1C1 we have not been successful in getting the value through DDE in the VB application. The error indicated is "NO FOREIGN APPLICATION RESPONDED TO A DDE iNITIATE".

Can anybody provide us any pointers in this direction? Are we missing out any settings in the EXCEL or VB applications

Any help in this is highly appreciated.

Thanks & Regards

Sandeep Shroff
___________________________________
Sandeep Shroff
Sr. Consultant
Remote & Embedded Technologies

rapidEffect (P) Ltd. 25, Napier Road, Pune 411001, India
Tel./Fax. +91-20-6363250
www.rapideffect.com
__________________________________________________
Web-intelligent solutions for enhanced ROI - get WISER with rapidEffect!

 

Sandeep,
Try this:

Private Sub Form_Load()

Text1.LinkTopic = "Excel|Sheet1"
Text1.LinkItem = "R1C1"
Text1.LinkMode = vbLinkAutomatic

End Sub

As a side note, I would highly advise against using VB's built-in support for DDE. I have found it to be very unreliable and unsuitable
for industrial applications. I have had very good luck using an ActiveX control from RHA Minisystems to handle DDE.
Refer to "http://www.angelfire.com/biz/rhaminisys/":http://www.angelfire.com/biz/rhaminisys/ , which also has an excellent DDE FAQ. (I am not affiliated with RHA Minisystems in any way.)

Good luck!

Brady A. Johnson
Software Engineer
[email protected]
Aberdeen Software Works
www.aberdeensw.com

 

Hi !

I just want to tell you that in VS.NET they have removed DDE. So if you want your app to evolve try something else. But on the other hand a DDE comm. is very simple to set up !

/Mathias