Vancad Posted September 9, 2014 Share Posted September 9, 2014 Our problem is this: We need to insert a block into an AutoCAD floor Plan, Each room has been sectioned off using a polyline. The block will read the Area, Length, Room names, Room numbers and a Hatch colour. We are creating an external Excel file which we will extract the data contained within the AutoCAD block into an Excel spread sheet. What we need is to be able to change information within the Excel spread sheet, (mostly the hatch colour) and have the AutoCAD drawing update automatically. It’s a two way communication we are trying to create between the AutoCAD file and the Excel File. Assistance is greatly appreciated. Quote Link to comment Share on other sites More sharing options...
BIGAL Posted September 10, 2014 Share Posted September 10, 2014 I take it by your post number that your new, firstly yes can be done, getting info from excel lots of examples just search here, to change the 1 block can be done you would search out all blocks of a certain name, then check for room number, then look for a hatch at this location and change color. I am pretty sure I did the 2nd part some time ago with code posted will try to find. Lastly do you have any experience in programming Autocad. Quote Link to comment Share on other sites More sharing options...
Vancad Posted September 10, 2014 Author Share Posted September 10, 2014 Thanks Big Al, I will have a look through the other posts for info, but any assistance is greatly appreciated. No I have no experience with AutoCAD programming. Hopefully their is something not too technical to make this work. Thanks, Again. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.