Findermb 发表于 2022-7-6 23:57:16

Can't edit attribute when

Hi there, I´m working with attribute blocks, and someone made an excel file with some data that has more than 1 line (That could be achieved pressing ALT+ENTER in excel) however when inserting the data with a coordinates MACRO, that attribute I can't edit those other lines of data, and when adding any information the other lines of data will be erased. Hope my hard english doesn't confuse you guys.
 
Attached you can find both the excel and the .dwg the data is not the same, but the block has the same attributes
 
EXAMPLE.xls
example.dwg

steven-g 发表于 2022-7-7 00:30:38

Can you post the macro as well, it might help someone figure it out, (but using the ALT+ENTER in Excel probably introduces special formatting codes which don't work in Autocad) it would be better to have the information in seperate cells in the Excel sheet.

Findermb 发表于 2022-7-7 01:22:11

Here is the MACRO, and I´m trying to separate the data, but there are over 15k of those blocks, and it will take me a long time to separate them manually.
 
Coordenadas.zip
页: [1]
查看完整版本: Can't edit attribute when