×
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 BOM data
2

Export BOM data

Export BOM data

(OP)
I am integrating SW into my company. I would like to export BOM data to an excel file, or better a csv file. Is there an easy way?

RE: Export BOM data

BOM data is already stored as an excel file.  Just double click BOM (or right click on BOM and select Edit Bill of Materials)on drawing and then copy and paste.

Regg

RE: Export BOM data

(OP)
Thanks Regg,
     I was hoping for something that did not involve cutting and pasting. My colleagues use ME10 at the moment, and so are not even regular windows users (sad or what!).

RE: Export BOM data

2
All you have to do is highlight the BOM in the drawing and click File\save as and it saves it as an .xls file

As for how SW04 BOMs will be I'm not sure at this time but I know the BOM's have changed in SW04.

Regards,

Scott Baugh, CSWP
3DVision Technologies
http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
When in doubt, always check the help

RE: Export BOM data

(OP)
Would you adam & eve, it is that simple!

Thanks Scott.

RE: Export BOM data

Scott,

A star for you.

Regg

RE: Export BOM data

Check out this Thread559-20992. The code found there can be easily modified to fit your needs.

Andrew

RE: Export BOM data

(OP)
Andrew,
     thank you very much. I was sure that this topic was not new.

Colin

RE: Export BOM data

netshop21:

Thanks for posting that reference. I knew we worked on that a ways back, but it saved me from searching for it.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Export BOM data

Hello dsi,

thank you again for that code. I used it in a macro in excel to transfer BOM information into an excel spreadsheet.

I think your program is a good candidate for FAQ.

Andrew

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