read a list dxf in excel

[nicolalocci]

hello to everyone and thank you in advance to anyone who wants to help me...

I have this problem: I have to rebuild irradiation lobes from a dxf list contained in a excel file that I attach to you: since they are old projects I saw that from that list they got a polylinea in a dxf file that then inserted in the sections.

what I ask myself is this: is there a tool or script that can read those data as they are formatted or are first edited? I tried everything I could think of but nothing.

Thanks again, nicola.

 

[rpor66]

the attached excel file is yours with the addition of a vba module containing the macro creatipline, to start having the excel file in the foreground and autocad open.
the vba module has as reference the autocad library 2012 type library, if your autocad is different you have to indicate the appropriate library.

bye

 

[nicolalocci]

perfect and thank you so much... That's what I needed. I take advantage of your competence... if the same macro you want to insert on another excel sheet that I have with other data lists?? Is it possible? I'll explain... in the same folder I have 6 spreadsheets for various frequencies and orientation.... thanks...

 

[rpor66]

Keep the file with the open macro, place you in the sheet and folder you want and call the macro.

bye

 

[nicolalocci]

Perfect. That's exactly what I was looking for... thank you very much....