Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Newbie here trying to understand how best to solve BOM

Newbie here trying to understand how best to solve BOM

Newbie here trying to understand how best to solve BOM

Hope I’m posting this in the right area...

I’m in IT by trade but I’ve been tasked with automating BOM after the quantity takeoff group hands over there numbers. After ALOT of research I am thinking that Excel VBA might be the best solution for doing this. Just thought I’d ask and get some feedback. This group is a specialty fence contractor and there are a lot of variables with BOM for fence because numerous configurations for each type of fence. Thought I would reach out here as I have sifted through many tools and not sure which way I should go. Anyone else in this trade have any feedback.


RE: Newbie here trying to understand how best to solve BOM

I think that'll give you job security, but that's about it. There are BOM routines for most CAD programs already and re-inventing the wheel is not particularly productive, overall.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Newbie here trying to understand how best to solve BOM


I've written some BOM routines in Excel VBA. They are recursive, that is the routine calls itself until the bottom of the BOM is reached (parent has no child).

So you would also need to access the DB. I used ActiveX Data Objects (ADO) with a Parameter query, where the individual components (children) you glean from the BOM are fed back as parts (parents).

Its been a while since I did this, as I've been retired about five years. This is Eng-TIPS.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close