AutoCAD and Precast Concrete

[cadmanrobb]

I am looking for a way to take and excel spreadsheet with information about drainage structures (manholes, catch basins, etc.) such as elevations, pipe type and sizes, structure size and create a drawing. Keep in my there could be hundreds of drawings required per project and I don't want to create that many drawing files. Any ideas or suggestions would be appreciated.

 

[borgunit]

Do you know LISP or VB?

"Everybody is ignorant, only on different subjects." — Will Rogers

 

[cadmanrobb]

I am know a small amount of each. I just started learning lisp and VB.

 

[borgunit]

Probably the easiest way is in vb since both ACAD and Excel can use vba natively. The routine below will get you the excel sheet (has to be already open) and then you can push and pull info from there. Let us know how you are doing...

Public Function GetOpenExcelWorksheet() As Excel.WorkSheet
'------------------------------------------------------------------------------
'StartExcel
'
'------------------------------------------------------------------------------
On Error GoTo ErrHandler
Dim sPath As String
Dim xlApp As Excel.Application
'''''''''''''''''''''''''''''''''''''''

Set xlApp = GetObject(, "Excel.Application")
'Set gWorkbook = gExcelApp.Workbooks.Open(sPath, , True)
Set GetOpenExcelWorksheet = xlApp.ActiveSheet
ErrHandler:
Select Case Err.Number
Case 429
Err.Clear
MsgBox "Existing Excel App not found"
Case Else
Err.Clear
End Select

End Function

"Everybody is ignorant, only on different subjects." — Will Rogers