Automate Autocad and excel

[manuelns]

Hello everybody.

 

I have an autocad drawing and an excel filewith 4000 names. I need to plot the same drawing with each of the names in the excel file. Is there a way I can automate this task? Thanks in advance for the advice. Manuel.

[Lee Mac]

4000 prints?!?

 

How many trees are you going to replant to compensate for that...!

[Lee Mac]

Back on topic though - what do you mean "names"?

 

Are they to populate attributes in the drawing?

[manuelns]

Back on topic though - what do you mean "names"?

 

Are they to populate attributes in the drawing?

 

Hi, thanks for your replay.

 

Sorry for not making myself clear, I have one drawing and need to plot it for each of the 4000 names in the excel file, that is, copy the first name in the excel file, paste it into the drawing, plot the file, copy the second name, paste it into the drawing replacing the previous name and plot the file and so on.

 

Thanks for your advice.

Manuel

[Lee Mac]

So you are just needing TEXT/MTEXT in the drawing at a certain point, containing the name.

 

I see you are using LT - this means LISP is out of the question, making things extremely difficult..

[manuelns]

So you are just needing TEXT/MTEXT in the drawing at a certain point, containing the name.

 

I see you are using LT - this means LISP is out of the question, making things extremely difficult..

 

 

Well, I also have the full version, is just that I use more LT because I almost never use 3d and lisp.

If you could just give the general idea, I have experience in Visual basic and other languages, so I think LISP wouln't be so difficult.

Thanks in advance.

[Lee Mac]

Take a look at this for a way to get info from excel

 

http://web2.airmail.net/terrycad/LISP/GetExcel.lsp