×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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!
  • Students Click Here

*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

Jobs

SWX BOM TABLE VBA QUESTION

SWX BOM TABLE VBA QUESTION

SWX BOM TABLE VBA QUESTION

(OP)
We have the need to export a single BOM from our Solidworks drawings, although the format of the drawings makes this somewhat complex - our drawings will have multiple BOM's across multiple,varying pages and we only want to export one BOM.

The actual code to export the BOM in the format we need is straightforward and not a problem. Where I need some help is in figuring out a way that allows the end-user to select a specific SWX BOM table in the feature manager (out of the 2 or 5 we might have) and to then address only that selected BOM with the export code.

All of the code that I've been able to find on the internet and in the help file wants to 'walk' through the feature manager using GetNextFeature and test each feature to see if it is a BOM and then export to a file if the feature is a BOM. Unfortunately we have the need to select a specific BOM table at run-time and then execute the export code against it.

Some other factors:
-BOM is SWX, not Excel
-BOM doesn't always have the same name


Any help is appreciated!!!

Vince

RE: SWX BOM TABLE VBA QUESTION

What is your experience level with VBA?  If you've already found code to "walk" through the feature manager and export BOMs, all you need to do is modify that code so that when it finds a BOM it highlights (selects) it and then asks with a message box "Do you want to export this BOM?"  The user might have to click "No" a couple of times to get to the desired BOM, but the code mods to accomplish this would be trivial.

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!


Resources