OK, here is the final on this; at least for now.
The included VBA application will NOT draw the pipes, if said pipes do not already exist in the drawing.
It also will not allow the user to alter any data in the export XLS file other than in the YELLOW columns, it simply ignores those edits and in some cases it will generate runtime errors.
However, IF the user creates the pipe runs as 'place holders' in the C3D drawing, then exports to Excel, and uses ODBC to Link ones design application database, or design formatted Excel workbook; then it does prove usefull. The user can then use the design application values to populate the exported workbook values and draft the pipes WITHOUT needing to deal with the fact that C3D will not adjust the invert of all pipes in the run through a single edit, as is possible in Pipes module of Civil Design within Land Desktop.
I am hopeful however that a couple of intrepid souls might be able to get this thing to draw pipes directly from the data in the design application or spreadsheet without the need to create the pipes within C3D first.
I want to thank those that have been of assistance. Thank You! Thank You! to SINC, and Jeff_M
