• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Civil 3D

    Reply
    Active Contributor
    najeebcad
    Posts: 38
    Registered: ‎07-15-2011

    PIPE2EXCEL.dvb in Civil 3D 2012 Pipe network analysis

    787 Views, 7 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

     

    Please use plain text.
    *Expert Elite*
    Posts: 1,250
    Registered: ‎09-05-2006

    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

     

    Please use plain text.
    Active Contributor
    najeebcad
    Posts: 38
    Registered: ‎07-15-2011

    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

    Please use plain text.
    *Expert Elite*
    Posts: 2,272
    Registered: ‎07-09-2003

    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/
    Please use plain text.
    Active Contributor
    najeebcad
    Posts: 38
    Registered: ‎07-15-2011

    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

    Please use plain text.
    *Expert Elite*
    Posts: 2,272
    Registered: ‎07-09-2003

    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/
    Please use plain text.
    Active Contributor
    najeebcad
    Posts: 38
    Registered: ‎07-15-2011

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

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

    Thanks Matt

    Please use plain text.
    Active Contributor
    najeebcad
    Posts: 38
    Registered: ‎07-15-2011

    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

    Please use plain text.