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 Contact USThanks. We have received your request and will respond promptly. 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 Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
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