BOM EXPORT TO EXCEL(linked)

Builder
Builder

Hi,

is there a way to export the BOM to excel but having it linked with SE so that it updates accordingly.

Thanks.

ST9
Conveyor and industrial equipment designer.
Giving SE a chance.
4 REPLIES

Re: BOM EXPORT TO EXCEL(linked)

what specfically are you wanting to update or work with...

 

there are other methds to do such but AFAIK you can not export an associative BOM...

 

There are data prep tools and other sort of tools that might help however that are biderectional but user prompted actions.

===================================================
Matt Johnson
Solid Edge Certified Professional (ST7 & ST8)
Solid Edge ST9 (SEEC) - Production
NX10 (Tc Integration) Pre-Production Testing
Teamcenter 10.1.6

Re: BOM EXPORT TO EXCEL(linked)

Builder
Builder

Our bom is used to order and cut material, but we have to copy content of the bom and save it in a excel files for others to use it and process it through out manufacturing. But when changes are made to this BOM errors can occure if we don't update de Xcel file.  So the "Copy content" and paste to xcel must be redone. As you said , probably data tools are the solution. Is there a vb.net code that I can start from to make my own utility?

Thanks,

ST9
Conveyor and industrial equipment designer.
Giving SE a chance.

Re: BOM EXPORT TO EXCEL(linked)

@Pedneault75  for SE Customization, API, Etc...   see The SE Developers form:

https://community.plm.automation.siemens.com/t5/Solid-Edge-Developer-Forum/bd-p/SEDeveloperForum

 

lots of great links and helpful code to get you started...

 

===================================================
Matt Johnson
Solid Edge Certified Professional (ST7 & ST8)
Solid Edge ST9 (SEEC) - Production
NX10 (Tc Integration) Pre-Production Testing
Teamcenter 10.1.6

Re: BOM EXPORT TO EXCEL(linked)

Valued Contributor
Valued Contributor

An exceptable work around could be to program following steps in your workbook open-event:

1: locate draft of the bom

2: open the draft in solidedge

3: copy bom from solidedge to excel

4: close solid edge.

Or inversily you could couple the save draftevent in solidedge to run a program which will update the excel with the right BOM.