Export excel table from SW assy macro

[13]

Hello all,

Is there a way to create an excel table from an assembly that would include custom properties? I am trying to output a spreadsheet from an assembly that would include part no, desc, qty, weight, and volume to do some further calculations.

Currently I have to manually click on each part to get these properties and then I manually enter them into a spreadsheet. And that, is time consuming!

Thanks in advance.

 

[MadMango]

Insert the Excel based Bill of Materials table in a SW drawing, then change the table Column properties to display any custom properties in your model. Then you can Save As the table back to Excel with all your data.

"Art without engineering is dreaming; Engineering without art is calculating."

Have you read faq731-376 to make the best use of Eng-Tips Forums?

 

[handleman]

You can also save a SolidWorks BOM as a CSV file.

 

[CorBlimeyLimey]

In SW07 you can save the BOM direct to Excel (.xls).

 

[ShaggyPE]

Check out Lenny's AssemblyBOM macro. It is available here:

http://www.lennyworks.com/solidworks/default.asp?ID=20

This macro will generate an assembly BOM within the context of an assembly and export it to excel. It has options to add certain custom properties. You may have to edit the macro to add additional custom properties.


-Shaggy

 

[13]

It seems that Lenny's macro was developed for SW2003 and will need some work--> and with my limited VBA experience this may prove to be a larger challenge.

Also I have SW 2007, but I can not save the BOM direct to Excel. I had to cut and paste and then save.

Thanks for your input, if any more ideas sprout up give me a shout.

 

[CorBlimeyLimey]

How did you try to save the BOM?

All you need do is RMB click on the BOM and select "Save as", and in the dialogue box which opens, the "Save as type" drop-down should offer the four format options. (.sldbomtbt, .xls, .txt and .csv)

Are you not being given those options?

 

[13]

no, those options are not in the short cut menu.

i also noticed that outside of solidworks you cannot copy file properties.

in inventor there is a utility that will allow you to do this, but i can't find a similar function in solidworks

 

[CorBlimeyLimey]

By "short cut menu" do you mean the list that appears when you right click (RMB) on the BOM?
Do you not see a Save as... option in that list?

 

[lexamk]

I'm also looking for a BOM macro that you can run from and Assembly. I downloaded Lenny's AssemblyBOM but am unable to edit the macro because I don't know VBA. All I want to do is change the PART NO column to extract the PartNo from the Custom Properties PartNo feild of each part. Lenny's macro seems to extract the name of the file and put that in the PART NO column. Because of our legacy data we're unable to save the part as the part number and must save it as the file name and add the part number to the Custom Properties. If anyone knows how to edit Lenny's macro so it will extract PartNo from the custom properties and place it in the PART NO column I would greatly appreciate it.

Thanks
Kevin

 

[cadcoke5]

I am in the same situation as CorBlimeyLimey, when I select the RMB the bom table in the tree, the "save as" option does not appear.

Joe Dunfee

 

[CorBlimeyLimey]

RMB the BOM in the drawing to see the Save as option. If you still don't see it, click the customize tab to see the list of options which are available.

 

[JMarv]

It may depend on what version of SW you have. In 2006, the option is actualy save as template not save as. After you select save as template, you can select what type of file you whant to save it as.

Joe
SW Office 2006 SP5.1
P4 3.0Ghz 1GB
ATI FireGL X1

 

[cadcoke5]

In my 2006 sp4.0 neither the "save as" nor "save as template" appears when I RMB the BOM on the tree or the drawing. If I "save as template" from the file menu after highlighting the bom, it will only offer the options for saving the drawing.

I suppose this is a limitation of my service pack. I will be going to sp5.1 soon, so hopefully that will solve the problem.

Joe Dunfee

 

[fcsuper]

13,

Try contacting Lenny about his macro. He has been willing to update his macros to suit user needs (just a matter of time as to when he can get to it).

Matt
CAD Engineer/ECN Analyst
Silicon Valley, CA
sw.fcsuper.com
Co-moderator of Solidworks Yahoo! Group