Siberian Posted March 14, 2008 Share Posted March 14, 2008 Anyone know how to make a BOM (bill of materials) in AutoCAD MEP? Can't seem to find any command or other way to achieve this... Quote Link to comment Share on other sites More sharing options...
RFRUSSO Posted March 14, 2008 Share Posted March 14, 2008 AutoCAD MEP?! Thjis is the Revit section my brotha' Quote Link to comment Share on other sites More sharing options...
tzframpton Posted March 14, 2008 Share Posted March 14, 2008 This is what I use. It creates an Excel Spreadsheet for all MvParts, and other tools used. Great program. Just add/enable it in your Macro Load menu (Cad Manager > Macro > Load Project...) and then run the file named "Main" at the end under your Macros Dialog Box. MEP_Information_Report.zip Quote Link to comment Share on other sites More sharing options...
Siberian Posted March 15, 2008 Author Share Posted March 15, 2008 So there really isn't a built-in thing for this...? Wierd... I can't seem to make your program work proparly. It keeps telling me "Can't find project or library". I so don't get VB Quote Link to comment Share on other sites More sharing options...
tzframpton Posted April 3, 2008 Share Posted April 3, 2008 So there really isn't a built-in thing for this...? Wierd...I can't seem to make your program work proparly. It keeps telling me "Can't find project or library". I so don't get VB Here is how you run it: Go to CAD Manager > Macro > Load Project. Now browse for the file and Open it from whatever directory you saved it under. Next, go to CAD Manager > Macro > Macros... and select the 4th option down as in the picture below (the modMain.main file) and hit the Run button. Then it will create the Excel BOM that you're wanting. Quote Link to comment Share on other sites More sharing options...
chee_dee Posted April 3, 2008 Share Posted April 3, 2008 book marked Quote Link to comment Share on other sites More sharing options...
chee_dee Posted April 5, 2008 Share Posted April 5, 2008 tells me it can't find project or library as well Quote Link to comment Share on other sites More sharing options...
SEANT Posted April 5, 2008 Share Posted April 5, 2008 One of the reason this will happen is if the project (.dvb) references a version of Excel different from what is on the current machine. From within the VBAIDE, look if anything is listed as "Missing" in References. If it is Excel, select the correct version (may have to scroll down to locate it) for the machine. Quote Link to comment Share on other sites More sharing options...
chee_dee Posted April 7, 2008 Share Posted April 7, 2008 these are whats missing: AEC MEP 5.5 Application Library AEC MEP 5.5 Base Object Library AEC MEP Plumbing 5.5 Base Object Library Quote Link to comment Share on other sites More sharing options...
SEANT Posted April 7, 2008 Share Posted April 7, 2008 Apparently this VBA project is very AEC MEP specific. If you are trying to use it with Standard AutoCAD 2007, the project will likely need modification to avoid tripping up on those missing libraries. Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted July 21, 2008 Share Posted July 21, 2008 Here is how you run it: Go to CAD Manager > Macro > Load Project. Now browse for the file and Open it from whatever directory you saved it under. Next, go to CAD Manager > Macro > Macros... and select the 4th option down as in the picture below (the modMain.main file) and hit the Run button. Then it will create the Excel BOM that you're wanting. Can you please add calculated plumbing lines size (in dia) also. Regards, ZERYAB Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted July 21, 2008 Share Posted July 21, 2008 I need to include Plumbing lines Dia also in your macro. Can u? please Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted July 24, 2008 Share Posted July 24, 2008 Great Program! It will be more useful if it can generate plumbing lines lengths with calculated pipe sizes (dia). Can you modify it and send it to me. Regards, ZERYAB Quote Link to comment Share on other sites More sharing options...
buzz Posted August 6, 2008 Share Posted August 6, 2008 I created a Duct Material Schedule that calculates sheet metal area, weight, liner area, lengths, etc. - it was done with the use of Property Set Definitions. You could accomplish the same thing for Piping. -Buzz Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted August 6, 2008 Share Posted August 6, 2008 Plumbing ducts do have parameters like length, dia meters etc, but plumbing lines do not, can you please check it, if there is any option? Quote Link to comment Share on other sites More sharing options...
buzz Posted August 6, 2008 Share Posted August 6, 2008 Piping objects do have Length, plumbing lines do too, but you have to add them to the Property Set Definitions... -Buzz Quote Link to comment Share on other sites More sharing options...
buzz Posted August 6, 2008 Share Posted August 6, 2008 Check out my blog site for the Duct Material Schedule... http://geniusoft.blogspot.com -Buzz Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted August 11, 2008 Share Posted August 11, 2008 You are genius, the information you have provided me really worked... thank you Quote Link to comment Share on other sites More sharing options...
ZERYAB Posted August 11, 2008 Share Posted August 11, 2008 but can you tell me the next procedure to create schedule for plumbing lines as its not available in the Shedule and Tag option for plumbing. please your quick reply is needed Quote Link to comment Share on other sites More sharing options...
jameslove2012 Posted January 2, 2012 Share Posted January 2, 2012 When the length of a pipe or duct is over 50000 units, the VB programme stopped, it said 'Overflow'. The problem line is follow: arrABS_Object(2, i) = CInt(arrABS_Object(2, i)) + aDuct.Length 'add one to the # of same column to the identical Duct Please correct it if you can, thank you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.