View previous topic :: View next topic |
Author |
Message |
noddy
Joined: 05 Jan 2006 Posts: 1 Location: Essex, England
|
Posted: Thu Jan 05, 2006 3:00 pm Post subject: Sending data from Excel using DDE |
|
|
Hi
I am trying to send data by DDE link to Dplot Jr from Excel (2002 version) but when I try to initiate the link Excel complains that it 'can't execute DPLOT.EXE'.
Clicking OK brings up 'Remote data not available. Start application DPLOTE.EXE?
Clicking yes gives brings up a VBA runtime error that DPLOT.EXE cannot be run the program or one of its components is damaged or missing.
This occured when I tried to set up a quick test link ( I copied your example from the DPlot help file):
Channel = DDEInitiate("DPlot", "System")
DDEExecute Channel, "[XY(0,0)][XY(1,1)][XY(2,4)]"
DDETerminate Channel
and also tried to run your example.xls excel file but this produces the same problem. I have checked the registry entry and it seems to exist in the correct place. I have set-up a DDE link with matlab in previous Add-Ins I have created which, although it took much trial and error, worked OK so I do have a limited understanding of VBA. I have not used links to library files before and so I thought I would try the DDE link first to see how useful this could be to me before trying the dll link. I'm probably being silly and it is something obvious but I can't see it. Thanks in advance. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Thu Jan 05, 2006 8:52 pm Post subject: |
|
|
This:
Channel = DDEInitiate("DPlot", "System")
looks for an application that's already running that responds to the DDE server and topic names "DPlot" and "System". It will not launch dplot.exe (or dplotjr.exe); you need to do that yourself within your VBA routine. If you look again at the example VBA code you'll find a function StartDPlot. You need to call that function first. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|