Community

using Excel data in an Autocad drawing

using Excel data in an Autocad drawing

Anonymous
Not applicable
333 Views
9 Replies
Message 1 of 10

using Excel data in an Autocad drawing

Anonymous
Not applicable
‎03-03-2001 03:46 PM
I am looking into the possibility of taking numerical data from an Excel spreadsheet and placing it into an
Autocad drawing as dimensions. My idea is that maybe this data can be associated with Acad attributes as
they have an identity that could be recognized. The dimensions are only reference so there is no need
for them to be to scale, only pictorially functional for marketing/sales info.

VB or LISP or ?? should be able to do this I think, any ideas or help would be appreciated.
0 Likes
Like
Report
334 Views
9 Replies
Replies (9)
Message 2 of 10

Anonymous
Not applicable
‎03-04-2001 05:50 AM
Hi Gerry,

 

Look in the sample files.  There is a VBA
program there showing how to read from and write to Excel.


--

 

Regards,

 



style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
I
am looking into the possibility of taking numerical data from an Excel
spreadsheet and placing it into an
Autocad drawing as dimensions. My idea
is that maybe this data can be associated with Acad attributes as
they
have an identity that could be recognized. The dimensions are only reference
so there is no need
for them to be to scale, only pictorially functional
for marketing/sales info.

VB or LISP or ?? should be able to do this I think, any ideas or help would
be appreciated.

0 Likes
Like
Report
Message 3 of 10

Anonymous
Not applicable
‎03-04-2001 01:13 PM
Thanks for the help Laurie, I got that to work fine even though it gave me an error.

My need is the opposite of what that program does, I want to get info from an Excel spreadsheet
and place it into an acad drawing. Can this program be modified for that or do you have another
idea that might help?

Thanks again.
0 Likes
Like
Report
Message 4 of 10

Anonymous
Not applicable
‎03-04-2001 07:13 PM
Hi Gerry,

 

Look at the program more closely.  It has two
way functions.


--

 

Regards,

 


 


style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
Thanks
for the help Laurie, I got that to work fine even though it gave me an error.

My need is the opposite of what that program does, I want to get info from
an Excel spreadsheet
and place it into an acad drawing. Can this program
be modified for that or do you have another
idea that might help?

Thanks again.

0 Likes
Like
Report
Message 5 of 10

Anonymous
Not applicable
‎03-04-2001 09:07 PM
If you'd like an example I wrote a macro in Excel
that has two way functionality (extracting, editing and updating attributes). It
is in the free downloads section of
href="http://www.BudCAD.com">www.BudCAD.com

 

Bud Miller


style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Hi Gerry,

 

Look at the program more closely.  It has
two way functions.


--

 

Regards,

 


 


style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
Thanks
for the help Laurie, I got that to work fine even though it gave me an
error.

My need is the opposite of what that program does, I want to get info
from an Excel spreadsheet
and place it into an acad drawing. Can this
program be modified for that or do you have another
idea that might
help?

Thanks again.

0 Likes
Like
Report
Message 6 of 10

Anonymous
Not applicable
‎03-06-2001 01:32 PM
Thank you Laurie and Bud, I will check out both of your ideas.
0 Likes
Like
Report
Message 7 of 10

Anonymous
Not applicable
‎03-08-2001 12:56 PM
I have another program ,it need some data of anonymous
block in working database .
0 Likes
Like
Report
Message 8 of 10

Anonymous
Not applicable
‎03-12-2001 01:56 PM
Your file doesn't seem to work for Acadr14, do you have another version?
0 Likes
Like
Report
Message 9 of 10

Anonymous
Not applicable
‎03-12-2001 01:57 PM
You said that the program works both ways but in none of the Acad or VB data could I find the way to do that.
If you could clarify that for me I would appreciate it. FYI this is to be used in Acadr14 and I have office 2000 loaded but I could load and earlier version of Excel if neccessary.
0 Likes
Like
Report
Message 10 of 10

Anonymous
Not applicable
‎03-12-2001 09:15 PM
Office 2000 is fine. It was written for
AutoCAD2000. I just need to swap references. I'll send it as soon as I
can.

 

Bud


style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
 You
said that the program works both ways but in none of the Acad or VB data could
I find the way to do that.
If you could clarify that for me I would
appreciate it. FYI this is to be used in Acadr14 and I have office 2000 loaded
but I could load and earlier version of Excel if
neccessary.
0 Likes
Like
Report
Report a website issue