×
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

Extracting data from SW non-excel BOM

Extracting data from SW non-excel BOM

Extracting data from SW non-excel BOM

(OP)
We have a macro that connects to the Excel BOM in an assembly drawing and transfers that information into an Excel spreadsheet assigning each piece of info to its specific column.

Is there a way to do something similar to assembly drawings using the new non-excel BOM?

RE: Extracting data from SW non-excel BOM

Netshop21, if you find an answer and don't mind sharing I would love to be able to do that was well.  Call it lazyness but I don't like retyping things.

RE: Extracting data from SW non-excel BOM

I just want to add a "Yeah, me too." to this.  If the info can't be exported into Excel, then is there a way to list all of the parts in a list format through SW itself?  I can't even cut and paste the BOM from a drawing.

RE: Extracting data from SW non-excel BOM

We use Microsoft Excel to control lengths of wires in our BOM’s. That means that if SolidWorks removes the Microsoft Excel from SolidWorks 2005 or if they do not give us the same functionality as the Microsoft Excel BOM has, we will not be able to upgrade. I have put in an enhancement request.

Bradley

RE: Extracting data from SW non-excel BOM

Is there a way to still use a Excel based BOM in 2004?

RE: Extracting data from SW non-excel BOM

I know you can save the bom info to a .csv file that excel can open up.  I don't have enough programming knowledge to get SW to save the .csv file, then call Excel to open the .csv, then copy and paste the info into the spreadsheet that we use.

To save a bom as a .csv
Select the bom and then do a File, Saveas, change the extension to .csv

RE: Extracting data from SW non-excel BOM

MattP,
    Highlight the view, in SolidWorks main menu, click Insert, Tables, Excel Based Bill of Materials…

Bradley

RE: Extracting data from SW non-excel BOM

Thanks Bradley, totally missed that.  Next question is, can you get each configuration of a part to show up as a separate line item?  

RE: Extracting data from SW non-excel BOM

Yogibear, the csv file trick temporily solves my problems.

Thanks,
Matt

RE: Extracting data from SW non-excel BOM

Matt,
   To my knowledge you cannot get each configuration of a part to show up as a separate line item on the same BOM.

Bradley

RE: Extracting data from SW non-excel BOM

Bradley:  I have somehow gotten different configs to show up indivudually in the BOM.  It doesn't list which configuration is which but that may just be a column that I don't have visible.

RE: Extracting data from SW non-excel BOM

If you are a good excel-macro-programmer it must be an easy exe to created using the command
retval = BomTable.GetEntryText ( row, col)

Can't be hard to create a SW and an Excel object get the values from sw and past them in excel using a macro

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