AutoCAD and Precast Concrete
AutoCAD and Precast Concrete
(OP)
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.





RE: AutoCAD and Precast Concrete
"Everybody is ignorant, only on different subjects." — Will Rogers
RE: AutoCAD and Precast Concrete
RE: AutoCAD and Precast Concrete
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