Excel data to AutoCAD
Excel data to AutoCAD
(OP)
I am looking to produce profiles, cross sections etc in AutoCAD by inserting a line of commands from an excel spreadsheet. How exactly is it done?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Excel data to AutoCAD
RE: Excel data to AutoCAD
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Excel data to AutoCAD
Sub Export2Microstation()
Dim channel As Long
With Selection
FRow = .Row
RowCt = .Rows.Count
LRow = FRow + RowCt - 1
FCol = .Column
ColCt = .Columns.Count
LCol = FCol + ColCt - 1
End With
task = "PLACE LINE" 'command entry in Microstation
'replace as needed
' keyin is a command to Microstation to use the command entry box.
channel = Application.DDEInitiate("ustn", "keyin")
Application.DDEExecute channel, task
For z = FRow To LRow
Range(Cells(z, FCol), Cells(z, FCol + 1)).Select
If Len(Cells(z, FCol)) = 0 Then
Application.DDEExecute channel, tast
Else
Application.DDEExecute channel, "XY= " & Cells(z, FCol) _
& "," & Cells(z, FCol + 1)
End If
Next
Application.DDETerminate channel
Range(Cells(FRow, FCol), Cells(LRow, FCol + 1)).Select
End Sub
RE: Excel data to AutoCAD
RE: Excel data to AutoCAD
Visit above site then u can find out what u want.
That is what exactly u want !
It is written in Korean !So I just wish there is Korean friends near u ~
That public free software can only be operated in ACAD 2000
It is written in LISP !
RE: Excel data to AutoCAD
Do you think this is a shareware or freeware?
Has anyone had any luck with program?
does it link up dynamically?
RE: Excel data to AutoCAD
At least this works with Quattro Pro, but I assume its the same.
Oh and it goes row by row if you paste in a 2d range.
RE: Excel data to AutoCAD