excel data to draw line in autocad.

[yonlih]

Dear all,

This is my first post on this forum.
I been using AutoCAD for two yrs and recently was trying to incorporate my calculation with excel to autocad.

my question here is,
I have a set of data in excel consists of two column, x column and y column,
how am i going to do in order my autocad will automatic plot a graph with the x and y value of my excel data sheet.
my idea was to create a button on my excel spreadsheet, when ever i change my parameter that affect my x and y column value, and press the button, it will link to my autocad and a graph will be plotted there.
is this sound possible?

I believe by using autolisp will be much more easier as it will perform the calculation and plotting of graph in autocad itself only, but the reason I create my calculation in an excel spreadsheet is because, some of the autocad users in my company are using autocad LT which not able to perform autolisp program. Therefore, I think to let them have an excel calculation for thier own parameter key in, and pass to some other colleugues who owns autocad which able to run lisp program and generate the graph for them.

I am new to excel marco and also autolisp language, please suggest me if u have any better idea.
Appreciate very much in advance for ur reply.

[fixo]

Dear all,

This is my first post on this forum.
I been using AutoCAD for two yrs and recently was trying to incorporate my calculation with excel to autocad.

my question here is,
I have a set of data in excel consists of two column, x column and y column,
how am i going to do in order my autocad will automatic plot a graph with the x and y value of my excel data sheet.
my idea was to create a button on my excel spreadsheet, when ever i change my parameter that affect my x and y column value, and press the button, it will link to my autocad and a graph will be plotted there.
is this sound possible?

I believe by using autolisp will be much more easier as it will perform the calculation and plotting of graph in autocad itself only, but the reason I create my calculation in an excel spreadsheet is because, some of the autocad users in my company are using autocad LT which not able to perform autolisp program. Therefore, I think to let them have an excel calculation for thier own parameter key in, and pass to some other colleugues who owns autocad which able to run lisp program and generate the graph for them.

I am new to excel marco and also autolisp language, please suggest me if u have any better idea.
Appreciate very much in advance for ur reply.

Try attached file
Open Autocad drawing
Open Excel file (AutoCAD must be opened)
Select four columns
Press button

~'J'~

[yonlih]

dear fixo,

thank you so much for your file.
I have just tried, but it return me with this error msg box when i press the button,
please see the attached jpeg.
i still figure it out why, not sure if it because of the autocad version.
I'm using the autocad mechanical 2010.
but some of my colleague are using autocad mechanical 2008 and some are LT.
but i think LT version are not able to do the line plot. correct me if i am wrong.
hopefully you can help to solve this. or giving some guildlines.
Many thanks.

[fixo]

dear fixo,

thank you so much for your file.
I have just tried, but it return me with this error msg box when i press the button,
please see the attached jpeg.
i still figure it out why, not sure if it because of the autocad version.
I'm using the autocad mechanical 2010.
but some of my colleague are using autocad mechanical 2008 and some are LT.
but i think LT version are not able to do the line plot. correct me if i am wrong.
hopefully you can help to solve this. or giving some guildlines.
Many thanks.

I'm working on A2009 only
You can try open VBA editor (Alt+F11 in Excel)
then go to Tools->References and change AutoCAD XXXX Object Library
on your current version - it would be marked as *MISSING* in there
Unfortunatelly I know nothing about VBA and LT release, sorry

~'J'~

[sanrajbhar677632]

This is what i am looking for. i picked all references related AutoCAD. i am using AUtoCAD map 2004. i faced this Error Kindly Check it. give me solution friends. Please !

For i = 1 To UBound(lineData, 1) ;gor Error here as "Run time Error 33, type Mismatch

Dim startPt(0 To 2) As Double
Dim endPt(0 To 2) As Double
startPt(0) = CDbl(lineData(i, 1)): startPt(1) = CDbl(lineData(i, 2)): startPt(2) = 0#
endPt(0) = CDbl(lineData(i, 3)): endPt(1) = CDbl(lineData(i, 4)): endPt(2) = 0#
Set oLine = aspace.AddLine(startPt, endPt)
Next i

I'm working on A2009 only
You can try open VBA editor (Alt+F11 in Excel)
then go to Tools->References and change AutoCAD XXXX Object Library
on your current version - it would be marked as *MISSING* in there
Unfortunatelly I know nothing about VBA and LT release, sorry

~'J'~

[strawmoped214590]

It works, it's amazing. How do You know this all Fixo? Where can I find some tips how to create such a connection between ACAD and Excel? I have much more questions but I don't want to bother you.

[fixo]

Glad if this working for you,
To be honestly I'm just an old homesitter and
do nothing but make the programs, piece by piece,
day by day, on many languages, its all my life...
Search this forum: Interaction between AutoCAD and Excel,
all 6 parts
Cheers

[Darren Allen]

Try attached file
Open Autocad drawing
Open Excel file (AutoCAD must be opened)
Select four columns
Press button

~'J'~

I am attempting the same thing. I have selected to four columns and pressed the button, Received "Compile Error: Cannot find project or library." Excel 2007 with ACADm 2012. Please advise, Thank you!

[fixo]

I am attempting the same thing. I have selected to four columns and pressed the button, Received "Compile Error: Cannot find project or library." Excel 2007 with ACADm 2012. Please advise, Thank you!

Hi Darren, I just tested this one on my AutoCAD 2010,
try to change references on your A2012 Relesase,
then let me know about

[Darren Allen]

Hi Darren, I just tested this one on my AutoCAD 2010,
try to change references on your A2012 Relesase,
then let me know about

Sorry, it took so long to reply. How do I change the references?