Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.
> 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