Extracting data from SW non-excel BOM

[dogarila]

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?

 

[Yogibear]

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.

 

[MattP]

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.

 

[Standing]

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

 

[MattP]

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

 

[Yogibear]

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

 

[Standing]

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


Bradley

 

[MattP]

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

 

[MattP]

Yogibear, the csv file trick temporily solves my problems.

Thanks,
Matt

 

[Standing]

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

 

[MattP]

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.

 

[Bouke]

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