AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Active Contributor
najeebcad
Posts: 38
Registered: ‎07-15-2011
Message 1 of 9 (1,110 Views)

PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

1110 Views, 8 Replies
09-12-2011 12:08 PM

Hi,

I'm using the PIPE2EXCEL.dvb (macro file) for my pipe network analysis. (Which I get from http://au.autodesk.com/?nd=class&session_id=3177)

 

Follow the steps as per the videos,

I tried to execute the Export to Excel (Attachment 01), but getting error message (Failed to execute Export to Excel - Attachment 02)

 

I'm not familier with Storm & Sanitary analysis 2012.  Using AutoCAD Civil 3D 2012, 64bit

 

Kindly have a look on my query

 

Thanks

Najeeb

 

*Expert Elite*
wfberry
Posts: 1,821
Registered: ‎09-05-2006
Message 2 of 9 (1,098 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-12-2011 01:14 PM in reply to: najeebcad

Since it has been over 2 years since Rad wrote that, perhaps you should send him your Question.

 

Bill

 

Active Contributor
najeebcad
Posts: 38
Registered: ‎07-15-2011
Message 3 of 9 (1,087 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-12-2011 02:11 PM in reply to: wfberry

Tried to send email, but the mail delivery has failed :smileysad:,

 

Anyone can give some ideas?

 

Thanks

Najeeb

*Expert Elite*
mathewk
Posts: 2,745
Registered: ‎07-09-2003
Message 4 of 9 (1,074 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-12-2011 06:10 PM in reply to: najeebcad

That VBA was not written for C3D 2012.  It will not work unless it is modified.  BTW, Rad does not work for Autodesk any longer, so that's why his email bounced back.

Matt Kolberg
Cansel - Autodesk Division
http://www.cansel.ca/
Active Contributor
najeebcad
Posts: 38
Registered: ‎07-15-2011
Message 5 of 9 (1,068 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-12-2011 08:25 PM in reply to: mathewk

Thanks Matt,

 

Could you please more specific about the editing of VBA files? (Like which area need to be modified)

 

regards

Najeeb

*Expert Elite*
mathewk
Posts: 2,745
Registered: ‎07-09-2003
Message 6 of 9 (1,060 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-12-2011 11:05 PM in reply to: najeebcad
Definitely the version number, but possibly more due to possible changes in the API. You'll need to hire a VBA programmer or find one in here to do it for free. If it's just the version number it will be a quick fix.
Matt Kolberg
Cansel - Autodesk Division
http://www.cansel.ca/
Active Contributor
najeebcad
Posts: 38
Registered: ‎07-15-2011
Message 7 of 9 (1,056 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-13-2011 12:02 AM in reply to: mathewk

Thanks Matt

Active Contributor
najeebcad
Posts: 38
Registered: ‎07-15-2011
Message 8 of 9 (1,020 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

09-14-2011 12:29 AM in reply to: mathewk

Hi,

I changed the version number & reference files in 2009 matched with C3D 2012 (attachment 01).

The macro file (PIPE2EXCEL.dvb) is working smooth in C3D 2012.


But....


When execute the IMPORT from EXCEL, Pipe size & slops are update automatically in plan and profile. Except the pipe size in labels, It is not update automatically, need to SWAP part (attachment 02)

 

Kindly have a look on my doubt

 

Thank you,

najeeb

Member
Paulns2
Posts: 4
Registered: ‎03-26-2012
Message 9 of 9 (189 Views)

Re: PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

10-29-2013 02:56 AM in reply to: najeebcad

Please post the macro. the link is dead.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.