Excel data to AutoCAD 1

• Apr 9, 2003

1
• #2

hbendillo

Electrical

Jan 24, 2003

88

US

Are you inserting lines of commands from the Excel spreadsheet to the command line of AutoCad? In other words are you wanting to insert command lines that will then be executed? I do not understand.

 

Upvote 0 Downvote

• Apr 10, 2003

• #3

dsi

Mechanical

Jul 20, 2000

574

US

Refer to thread555-51546 DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

Upvote 0 Downvote

• May 19, 2003

• #4

NOEd

Coastal

May 14, 2003

7

US

This works for Microstation. Notice that Microstation is called "ustn". You'll need Windows' internal name for Autocadd but this demonstrates the link:

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&quot

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

 

Upvote 0 Downvote

• Jun 5, 2003

• #5

mstg007

Civil/Environmental

Jun 2, 2003

40

can we code something like this up for autocad

 

Upvote 0 Downvote

• Jun 6, 2003

• #6

Chunil

Geotechnical

Mar 15, 2001

31

KR

http://myhome.hanafos.com/~xout/Excel/Excel_Funtion_list.htm

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 !

 

Upvote 0 Downvote

• Jun 9, 2003

• #7

mstg007

Civil/Environmental

Jun 2, 2003

40

lol how hard is it to read another language? other than english lol...

Do you think this is a shareware or freeware?

Has anyone had any luck with program?

does it link up dynamically?

 

Upvote 0 Downvote

• Jun 12, 2003

• #8

ivanlocke

Civil/Environmental

Jan 23, 2003

60

US

If you have full commands in Excel cells you can just copy and paste into Autocad and they will run. You must click on the command line in Autocad or else you will paste the Excel cells into the drawing.
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.

 

Upvote 0 Downvote

• Jun 23, 2003

• #9

mpsaju

Mechanical

Nov 6, 2002

6

IN

Please see thread 555-51546 in Tips for AUTOCAD

 

Upvote 0 Downvote