Search the Community

Hello all, I tried looking this up and did not quite find what I needed. I have hundred of rooms that I have created closed polylines. The rooms also have single line text with the room number. I want to link each space in the floor plan to an Excel spreadsheet. Each space will need to have an identifier – e.g. room number – in its properties and in its corresponding record on the spreadsheet. I’m dealing with a lot of rooms, so I’d rather not have to number each space in manually. All of the rooms on the floor plan in the dwg file are polylined and all of the polylines are on the same layer of the dwg file. This layer contains nothing but the polylines. I also have another layer that has room numbers for each polylined room. The only thing on this layer are the room numbers as mtext objects. The mtext objects aren’t linked to their respective polylines, after I run DATAEXTRACTION Is there a way to associate a room number with each polyline in AutoCad? Can I store the room number in AutoCad as xdata associated with each polyline and somehow have it recognize it as a property of each space? Is there any way to create a custom property for polylines in AutoCad that the room number can be stored in? I'm using AutoCAD 2015. Thank all in advance

Hi, I need to extract Information ("General": Color, etc. and "Geometry": Length, Start Y, End X, etc.") from AutoCAD to an Excel-Sheet using VBA. First I've tried it manually in AutoCAD with the commands DATAEXTRACTION and EATTTEXT and it works. Also I've tried entering in VBA "SendCommand ("DATAEXTRACTION" & vbCr")", then an AutoCAD-window is opened and I have to click on "Next" several times and to specify the folder where I want to save the file. I want that VBA does all this process without the window appearing (I mean "without clicking on "Next" several times and specifying the file path"). Obvious the User has to Input into the code the location where he wants to save the file with the extracted information). Instructions als "For Each Object in ModelSpace: Line.StartPoint, Line.Color, etc." don't help me unfortunately because this way slow down the VBA-program. May anyone help me? Thanks! Regards,

Is any one using this for generating part lists? (http://heidihewett.blogs.com/my_weblog/2007/02/tables_from_dat.html) I have some problems with it: Doesn't generate Item number need to do this by hand. Can save data extraction plan but can't update the selection set without going true all settings. Can't select blocks in modelspace if I am in paperspace, where the table should be. Does any one knows a good work around or a way to fix this issues?