• This forum is the machine-generated translation of www.cad3d.it/forum1 - the Italian design community. Several terms are not translated correctly.

macro for symbols insertion

gennarochiocca

Guest
Hello everyone, I am a novice of this forum. I need some suggestions.

objective : to realize a function that gives an external table in excel format, read the values of a column and insert in the drawing a symbol that has the same name as the value of the cell belonging to the read column.

I'll explain.

I have an excel file, the first column contains the cod.product of physical objects. Suppose it has 3 product cod.
e.g. ab-001, ab-002, ab-003.

the function I want to create inserts the symbols that I previously built with the names ab-001, ab-002, ab-003.

Thank you all.

p.s. : use autocad r14
 
with a macro is impossible, you can with programming (lisp, vba, .net, etc.).
If you really use the r14 maybe it remains only vba.
 
a quick (moderately) way is to export the excel column with data, in a csv file and then editing the file with the wordpad, turning the csv row sequence into a script file

In all cases if you really use r14, I wonder if there was excel for dos. I have no memory.
 

Forum statistics

Threads
44,997
Messages
339,767
Members
4
Latest member
ibt

Members online

No members online now.
Back
Top