get detail element information into DB

Element Data

The Element object is the base class for graphic elements such as TextElement or CellElement. The Element.ID property provides the element ID of any element type. A text or cell element has the Origin property.

Dim oCell As CellElement
 ... get oCell from somewhere
Debug.Print "Cell ID " & DLongToString (oCell.ID) & " name=" & _
  oCell.Name & _
  " origin=" & CStr (oCell.Origin.X) & "," &  CStr (oCell.Origin.Y)

Scanning

The process of obtain element data from all the elements in a DGN model is called scanning. The ModelReference.Scan method gets an enumeration of elements. You can filter the elements found by the scanner by creating an ElementScanCriteria object. You'll find exampls in VBA Help.

DB Interface

VBA has no built-in DB capability. You should download Microsoft's ActiveX Data Objects (ADO). ADO provides rich DB functionality, and is well-documented on the web. We've written an article about Databases and MicroStation. It includes a link to Microsoft's ADO download site.

Regards, Jon Summers
LA Solutions