×
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

Exporting Solid Works BOM to Excel
2

Exporting Solid Works BOM to Excel

Exporting Solid Works BOM to Excel

(OP)
using sw2007 sp3.0 i have been coping and pasting sw bom from bom contents to excel. Is there a way to directly export sw bom to excel?

RE: Exporting Solid Works BOM to Excel

adn1975,

You can save the BOM out as a CSV or text file and import it into Excel.  If you know API programming, you can write a routine (it may already be posted in the forum somewhere)and directly transfer it.

Regards,

Regg

RE: Exporting Solid Works BOM to Excel

(OP)
regg thanks. right click on bom save as. i didn't see it. this forum is great!!! I've a SW user since 98 and i still pick up tips by browsing.

RE: Exporting Solid Works BOM to Excel

ADN1975,

You do not right click.  You left click on the BOM then go to file-save as.  Then make sure you change "save as file type" to .csv.  Then save the file where ever you would like.  One thing that I noticed.  I am running 2006 sp4.0 and when I open the .csv file in excel the cells will not load properly if I have a comma in the fields.  I imagine the comma tells Excel to move to the next cell because that is what happens to me.  If I remove all commas I have no problems.  

Take care

RE: Exporting Solid Works BOM to Excel

(OP)
brian, in 2007 it is a RMC then save as. LMC does nothing. I found that saving as a text file then opening in excel, you do not have the comma issues.

RE: Exporting Solid Works BOM to Excel

ADN1975,

Since you are running SW 2007 you can save the BOM directly to an excel file by using the file save as ".xls" command. This puts all data in the proper place on the excel file and commas are accepted. Let me know if you have any questions.

Mike G.

RE: Exporting Solid Works BOM to Excel

ADN1975,

Thank you for the info.  You are correct saving as txt eliminates my problem.  A star for you.

RE: Exporting Solid Works BOM to Excel

jmg108,

Since I have a macro that does this, I did not know that you could now save BOM table as xls.  Have a star.

Regards,

Regg

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