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.
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
RE: Export BOM 07
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
Select the Excel Bom then File > Save As...
RE: Export BOM 07
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.
RE: Export BOM 07
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
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
RE: Export BOM 07
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
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
RE: Export BOM 07
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
RE: Export BOM 07
RE: Export BOM 07
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
Check out the AssemblyBOM macro from http
RE: Export BOM 07
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 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.