×
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

Export excel table from SW assy macro

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.

RE: Export excel table from SW assy macro

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: Eng-Tips.com Forum Policies to make the best use of Eng-Tips Forums?

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

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

cheers

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

(OP)
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.  

RE: Export excel table from SW assy macro

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?

cheers

RE: Export excel table from SW assy macro

(OP)
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 :(

RE: Export excel table from SW assy macro

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?

cheers

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

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.

cheers

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

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

RE: Export excel table from SW assy macro

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

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