I authored a FAQ on the Eng-tips (www.eng-tips <www.eng-tips> ) forum that collects up things I have found on the internet relating to Using Microsoft Excel with Pro/ENGINEER (http://www.eng-tips.com/faqs.cfm?fid=905 <http: www.eng-tips.com=" faqs.cfm?fid="905"> ).
The best way to do what you want is detailed in this link:
* Drive Your Pro/ENGINEER Model with a Spreadsheet <http: www.profilesmagazine.com=" p22=" tips_muirhead.html="> by Edwin Muirhead. From the Winter 2002 issue of Profiles Magazine.
I use things like this all the time it works great. Kudos to Edwin!