Export excel table from SW assy macro
Export excel table from SW assy macro
(OP)
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.
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.






RE: Export excel table from SW assy macro
"Art without engineering is dreaming; Engineering without art is calculating."
Have you read FAQ731-376: Eng-Tips.com Forum Policies to make the best use of Eng-Tips Forums?
RE: Export excel table from SW assy macro
RE: Export excel table from SW assy macro
RE: Export excel table from SW assy macro
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
RE: Export excel table from SW assy macro
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.
RE: Export excel table from SW assy macro
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?
RE: Export excel table from SW assy macro
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 :(
RE: Export excel table from SW assy macro
Do you not see a Save as... option in that list?
RE: Export excel table from SW assy macro
Thanks
Kevin
RE: Export excel table from SW assy macro
Joe Dunfee
RE: Export excel table from SW assy macro
RE: Export excel table from SW assy macro
Joe
SW Office 2006 SP5.1
P4 3.0Ghz 1GB
ATI FireGL X1
RE: Export excel table from SW assy macro
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
RE: Export excel table from SW assy macro
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