Solution - Convert a BOM from drawing to excel spreadsheet

[ptc-1935566]

Select the table and then Table Menu -> Save Table -> as txt file. WF3
gives you the option to save as csv files now.



I don't know of any way to get Excel to drive Pro/E other than using one
of the APIs (which I have never done myself)



Chris



Thanks for your help!



Brian A. Enlow

Product Designer

Delta Faucet Company





This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[MarcMettes]

> I don't know of any way to get Excel to drive Pro/E other than using one
> of the APIs (which I have never done myself)

You can transfer data between Pro/Engineer drawing tables and Excel (in both
directions) using the free Pro/WebLink API, which is already included in your
Pro/Engineer installation.

Steps to setup Pro/WebLink:
http://inversionconsulting.blogspot.com/2008/07/proe-weblink-getting-started-tips.html

Code for Excel to drawing table transfers:
http://inversionconsulting.blogspot.com/2008/06/weblink-excel-to-proe-drw-tables-part-1.html

Code for drawing table to Excel transfers:
http://inversionconsulting.blogspot.com/2008/06/weblink-excel-to-proe-drw-tables-part-2.html

If you or your users do not have at least "Power User" privileges, you will
probably need to have an admin user run the program first. Pro/WebLink (and
VB API) uses a number of ActiveX controls that can only be registered with
Windows by a user with enhanced privileges.

Send me an email if you have any trouble with the program.


Marc
--
Marc Mettes
-
Visit My CAD/PDM AutomationBlog
Or, Subscribe to My CAD/PDM Automation Blog by Email