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,152 Views)

PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

1152 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,914
Registered: ‎09-05-2006
Message 2 of 9 (1,140 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,129 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,767
Registered: ‎07-09-2003
Message 4 of 9 (1,116 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,110 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,767
Registered: ‎07-09-2003
Message 6 of 9 (1,102 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,098 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,062 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 (231 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.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!