Visio 2003 Professional- 1- LInk Data from Excel 2-Export this Data to Excel

Visio 2003 Professional- 1- LInk Data from Excel 2-Export this Data to Excel

Cancelled

Job Description

This is 2 parts. I have a library of shapes (stencils) that I'd like to link data to from an Excel file (Product & price).
When I create the new drawing, I'd like the data from the "shape" (product, cost) to transfer to an Excel sheet.

Basically, I'm using Visio 2003 Professional as a basic CAD program and am exporting it for job costing from the design. Here's screenshots of what I'd like it to do.
Full screen: http://screencast.com/t/FWbTNnhoN1an
Result: http://screencast.com/t/HQeVjSkiqFz

The "Result" image shows a window w/in Visio, but that doesn't matter as much. Just that it will add the products and the total.

****I'd like to add the product data in continuously as new products are added, and I'd like to update the products as the pricing is changed.

---
Skills: drawing