New SE user; How can I autofill some bom details into excel?
New SE user; How can I autofill some bom details into excel?
(OP)
Our shop uses an excel form that includes the item number, quanity and material along with alot of other columns that they fill out for routing the machining. Can we have SE at least populate the first three columns for them?





RE: New SE user; How can I autofill some bom details into excel?
At least a couple of ways in fact. Are you using any kind of PDM system as this may change things a little or add extra ways.
The way I usually do it (V19) is left mouse click on the assy in Windows Explorer and select reports. You can also get to here from an open assy by going to tools, reports.
Once here it should be fairly self explanatory, play around with it a little. There are several options which have some built in standard columns but you can add or remove columns for pretty much any file property.
When you've got all the columns you want, go to save as. Sadly it doesn't have excell as a file type you can save as but, by saying save as .txt and then changing the file extension to xls before you actually save you can get it out in an excel sheet.
It will act a little funny the first time you open & save it but should be fine.
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
I don't know exactly what your set up is, what you want, what file properties you use etc so I can't give you a step by step.
Like I said, play around with it.
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
Maybe someone else on here can help.
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
you can create a partslist within the draft. Then RMB into
the partslist and select 'Copy Contents'. In Excel just
do CTRL-V or RMB into a cell -- Paste
The item numbers shown within the draft's PartList are stored
within the draft *not* within the underlying part
dy
RE: New SE user; How can I autofill some bom details into excel?
RE: New SE user; How can I autofill some bom details into excel?
is non associative. To have that one has to do some
programming.
dy
RE: New SE user; How can I autofill some bom details into excel?
What is Engineering anyway: FAQ1088-1484: In layman terms, what is "engineering"?