×
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 07

Export BOM 07

Export BOM 07

(OP)
I need to export a BOM from SolidWorks 07. I've searched other threads and have found nothing.  Sounds to me like this is not an option anymore.

Goal.
We use an excel based BOM and need to either export it out to a seperate excel file or extract the part number and quantities from the SW BOM to input in to our order form software.


I think exporting the part number and quantities to a "extrenal" excel file would be the easiet option.  That way we can just import that excel file into our order form software.

Thanks fot any help.

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

RMB on the BOM and select Save As...

cheers

RE: Export BOM 07

(OP)
To my knowlegde thats only for SW BOM not an excel based BOM

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

Oh sorry, I must have missed the part where you didn't mention it was an Excel BOM. lol

Select the Excel Bom then File > Save As...

cheers

RE: Export BOM 07

[deep sigh]

I read and re-read your post several times and still didn't see the excel reference. I think my brain no longer recognises those !@#$%^ double underlined links ... or it's shutting down early for the holidays ... or I'm just losing it.

cheers

RE: Export BOM 07

(OP)
I did mention it in the orignal post under "goal".  
Anywho....

If you double click the BOM., file is "running" in SW not excel (if that makes sense) and the save icon in excel is grayed out.  Is it possible to open it in another window (in excel) like a design table?

see pic.

Thanks for your help.

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

I do this all the time--export SW BOM to Excel format, right?  CorBlimeyLimey's instructions are correct.

Jeff Mowry
www.industrialdesignhaus.com
What did you dream?  It's all right--we told you what to dream.
    --Pink Floyd, Welcome to the Machine

RE: Export BOM 07

Don't double-click ... just single-click then File > Save As...

cheers

RE: Export BOM 07

Just checked your image--doesn't look like mine.  I just right-click anywhere on the BOM itself in the drawing and select Save As.  Can save as a template, Excel, text, or CSV.

Jeff Mowry
www.industrialdesignhaus.com
What did you dream?  It's all right--we told you what to dream.
    --Pink Floyd, Welcome to the Machine

RE: Export BOM 07

(OP)
Wonderfull!!

Thanks!! Sorry for the confusion!  



Thanks again.

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

Theo .. I made the same mistake of mis-reading and assuming SW to Excel, but he wants Excel to Excel.

cheers

RE: Export BOM 07

(OP)
opps to CBL^^

can one edit ther posts on this forum?

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

You can request edits via the Inappropriate post? If so Red Flag it! function located at the bottom-centre of each post.

cheers

RE: Export BOM 07

Open an Excel window, open your  Excel-based BOM in SW, and cut/paste to your heart's content.

RE: Export BOM 07

(OP)
Yeah...but our goal is to write a macro to automate the process.  As of right now we take our BOM and type in all the componets into our order form.  We'd like to speed that up and cut down on errors.

Is it possible to write a macro to open excel pull data from 2 columns of an EXCEL BASED BOM then "paste" them into that excel file that opened and save?

Thats all the farther I have to go then it's up to our IT people to import it into our order form software with some sort of macro.

Thanks

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

(OP)
Yeah I've looked at that it's a definite possiblity.

I think we'd have cut some of the fat off.  As we dont need that much info nor it to be that elborate.

Was hoping some one had an example I could modify.  Was thinking that's be easier than deleting all the stuff we wouldn't need from Lenny's.

Thanks.

Grant
Applications Engineer
SW2007 SP 3.0
IBM InteliStation Pro M
P4 3.4 GHz, 2GB RAM
XP Pro SP2.0
NIVIDA Quadro FX 3000

RE: Export BOM 07

I have a macro I wrote in Excel VBA which attaches to an open SW assembly drawing, looks for the BOM, reads the BOM, opens the model associated with the view the BOM is attached, reads the description of the model, closes the model, returns to excel and writes down the info collected according to certain instructions so everythhing comes down in neatly arranged rows. It used to work for an excel based SW BOM but I modified it a few years ago to work for a SW BOM only.
I can send you this macro if you want (or post it here) and you can change it to work for you. I and the API and VB gurus around here will help you. You may want to consider switching to SW BOM permanetly.

At some point in time I had this macro working on a bunch of drawings in a folder. I mean making a list of drawings in the folder, opening the first drawing, processing, closing it, opening the second drawing, processing, closing it and so on. I didn't find it very useful so I removed those lines from the program. I am mentioning it here to let you know it could be done if so you wish.

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