Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel DDE to Autocad Problem

105 views
Skip to first unread message

mcdo...@failure.com

unread,
Dec 9, 1995, 3:00:00 AM12/9/95
to

I have many Excel spreadsheets that communicate with ACAD
through Visual Basic DDE messages. The spreadsheets are
written in Windows forWorkgroups for windows AutoCad 12.x.
We have recently upgraded to Windows NT3.51 and Autocad 13
for windows, and the DDE link no longer works. I cannot
find documentation for this in AutoCad 13.c3 package.

The following is an excerpt from a visual basic program
that reads data from the worksheet and plots it in AutoCad.
It assumes AutoCad is running when it is launched. Before
anything happens, I get an error message such as "cannot
find Autocad..exe. Load now? y/n" Does anybody know what
the eauivalent DDE initiate line is in NT and ACAD13????

Sub DrawNodes()
ichannel = Application.DDEInitiate("AUTOCAD.DDE", "System")
While Not((IsEmpty(Worksheets("Node_Map").Cells(irow, 2).Value)))
x = Worksheets("Node_Map").Cells(irow, 2).Value
y = Worksheets("Node_Map").Cells(irow, 3).Value
z = Worksheets("Node_Map").Cells(irow, 4).Value
cmd = "[Point "&CStr(x)&","&CStr(y)&","&CStr(z)&Chr(10)& "]"
Application.DDEExecute ichannel, cmd
irow = irow + 1
Wend
End Sub

Paul Taylor

unread,
Dec 13, 1995, 3:00:00 AM12/13/95
to
> Does anybody know what
> the eauivalent DDE initiate line is in NT and ACAD13????
>
> Sub DrawNodes()
> ichannel = Application.DDEInitiate("AUTOCAD.DDE", "System")

In R13, the DDE topic name is "AutoCAD.r13.DDE|System"

There is NO documentation on this subject. At least, none that I could
find. You have to dig for it...... :(

Paul Taylor, Computer Services Manager
WSP Consulting Engineers, Tadworth, Surrey, UK.

mcdo...@failure.com

unread,
Dec 16, 1995, 3:00:00 AM12/16/95
to

In article <DJJn4...@cix.compulink.co.uk>, <a...@cix.compulink.co.uk> writes:
> Newsgroups: comp.cad.autocad
> Path: failure.news.pilot.net!news2.pilot.net!ns.pilot.net!news.sprintlink.net!howland.reston.ans.net!newsfeed.internetmci.com!btnet!news.compulink.co.uk!cix.compulink.co.uk!usenet
> From: a...@cix.compulink.co.uk ("Paul Taylor")
> Subject: Re: Excel DDE to Autocad Problem
> Message-ID: <DJJn4...@cix.compulink.co.uk>
> Organization: Compulink Information eXchange
> References: <NEWTNews.818552...@bjohnsonnb.fail.com>
> Date: Wed, 13 Dec 1995 21:16:51 GMT
> X-News-Software: Ameol32
> Lines: 13

Thanks for the advice. The syntax of the initiation line for Excel
Visual Basic macro (Office 95 running on NT, Acad 13.c3) is:

ichannel = Application.DDEInitiate("AUTOCAD.r13.DDE", "System")

This worked like a charm.

John Ayre

unread,
Dec 22, 1995, 3:00:00 AM12/22/95
to mcdo...@failure.com
Funny, isn't it?
Use regedit EVERY TIME you need to use DDE to communicate with
Application.
In programm manager: File/Run/Regedit, fine AutoCAD R13 and
see thet application name NOW IS: AutoCAD.r13.DDE.
Jus in case, for LT it is: AutoCAD.LT
Regards,
Have fun in DDE-world
Serg,
spe...@ozemail.com.au


0 new messages