I work for an architectural firm & we produce drawings for permit. On our titleblock we have the state license number & the license expiration date. We use a series of lisp routines that copies a set of drawings to a specific project directory then opens the title block drawing & populates it with text based on an ascii file that the routine creates. This works ok but sometimes the expiration date changes & the title block needs to be updated. Currently we are depending on the user to manually update this. I would like to find a way to automatically update this when you plot or save much like a field would do. The problem is that i would need it to recognize what state the project is in & be able to connect to a specific cell in a specific excel spreadsheet. I know how to connect to an excel file through a data link but the problem is i would need it to connect to a specific cell based on the state that the project is in. Someone suggested having an xrecord established in the drawing. I am looking for a way to have it so it would update automatically so i wouldn't have to depend on the user to update it manually.
