Code Red > AutoLISP (Vanilla / Visual)

Dynamic Data Exchange (DDE) method

(1/1)

HofCAD:
Dear Readers,

What is possible with the Dynamic Data Exchange (DDE) method
with AutoCAD(LT) and Excel?
Who is using the Dynamic Data Exchange (DDE) method?

HofCAD CSI

PS This is possible:
HofCADLT.xls
HofCADLT.xls
Change green values and click on the yellow Update, and look to the result in AutoCAD.
May be you have to change at the top of the macro's:
Const ver As Integer = 16
Const arr As String = "-ARRAY"



<Edited to remove broken links>

Maverick®:
What application would you use this for?

All the links you posted come up broken.

HofCAD:

--- Quote from: Maverick® on September 11, 2006, 11:59:06 AM ---What application would you use this for?

All the links you posted come up broken.

--- End quote ---

Sorry, I try again.

Dear Readers,

What is possible with the Dynamic Data Exchange (DDE) method
with AutoCAD(LT) and Excel(or Winword)?
Who is using the Dynamic Data Exchange (DDE) method?
It is not AutoLisp(VisualLisp) or VBA, and you can also use it in AutoCAD LT.

HofCAD CSI

PS General explanation:
Example for opening document C:\temp\hoftest.doc with a macro in Excel.

Sub Test()
ChanNum = DDEInitiate("winword", "c:\temp\hoftest.doc")
For i = 0 To 9
DDEExecute ChanNum, "Line" + Str$(i) + "{ENTER}"
Next i
DDETerminate ChanNum
End Sub

See documents in:
LINK

Use in AutoCAD
See de macro's:
LINK to HofCADLT.xls
HofCADLT.xls
Change green values and click on the yellow Update, and look to the result in AutoCAD or AutoCAD LT.
May be you have to change at the top of the macro's:
Const ver As Integer = 16
Const arr As String = "-ARRAY"
LINK2
LINK3
LINK4
LINK5

- EDIT -

Repaired Links

HofCAD:

--- Quote from: HofCAD on September 11, 2006, 04:42:12 AM ---Dear Readers,

What is possible with the Dynamic Data Exchange (DDE) method
with AutoCAD(LT) and Excel?
Who is using the Dynamic Data Exchange (DDE) method?

HofCAD CSI
--- End quote ---

Dear Readers,

This also possible with the Dynamic Data Exchange (DDE) method.
http://www.theswamp.org/screens/HOFDDE03.XLS

HofCAD CSI

PS Change green values and click on the yellow Update, and look to the result in AutoCAD or AutoCAD LT.
May be you have to change at the top of the macro's in Module1 (Alt+F11):
Const ver As Integer = 16

Navigation

[0] Message Index