CAD Forums > The Third Dimension

Copy Pipe Network Values from Prospector to Excel

(1/2) > >>

MSTG007:
I know i can do this manually, but I thought i would ask if there is a routine or what not which could copy all the pipe network values to a clip board and paste them into an excel file? Just thought i would ask.

Jeff_M:
There is a sample .NET project that is included with the C3D install to export and import pipe/structure data to/from Excel.

MSTG007:
Thanks for pointing that direction for me. I did get a little curious and looked into the VBALoad PipeSample.dvb. It did work running it from within Civil3D.

How would I get the PipeSample.dvb to work within Excels VBA environment? I have a xlsm which i copied all the ACAD VBA modules over to Excel Modules.

Honestly, I thought it would be able to run the same code as within the ACAD environment in the Excel environment. No such luck and not really sure how to make them connect.

Jeff_M:
Sorry, I left VBA behind 13 years ago. I really have no idea how to work with C3D objects from an Excel VBA app.

huiz:
You could easily do that in Dynamo or if you have access to the Project Explorer you can use that.

Navigation

[0] Message Index

[#] Next page