TheSwamp

CAD Forums => CAD General => The Third Dimension => Topic started by: MSTG007 on September 15, 2021, 08:30:25 AM

Title: Copy Pipe Network Values from Prospector to Excel
Post by: MSTG007 on September 15, 2021, 08:30:25 AM
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.
Title: Re: Copy Pipe Network Values from Prospector to Excel
Post by: Jeff_M on September 15, 2021, 11:35:01 AM
There is a sample .NET project that is included with the C3D install to export and import pipe/structure data to/from Excel.
Title: Re: Copy Pipe Network Values from Prospector to Excel
Post by: MSTG007 on September 15, 2021, 02:56:41 PM
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.

Title: Re: Copy Pipe Network Values from Prospector to Excel
Post by: Jeff_M on September 15, 2021, 03:59:37 PM
Sorry, I left VBA behind 13 years ago. I really have no idea how to work with C3D objects from an Excel VBA app.
Title: Re: Copy Pipe Network Values from Prospector to Excel
Post by: huiz on September 15, 2021, 05:03:39 PM
You could easily do that in Dynamo or if you have access to the Project Explorer you can use that.
Title: Re: Copy Pipe Network Values from Prospector to Excel
Post by: MSTG007 on September 16, 2021, 07:54:40 AM
Sounds good. Thanks!