Excel ODBC and Shape properties in Visio 2003

D

Dan

Verison: Visio 2003 Pro
Excel: Office XP version w/service packs installed
OS: Windows XP Home edition

I'm trying to create an excel file that controls a Viso shape's color in a
drawing.

- The excel file contains a due date, formula of the number of days
remaining and a formula to state the colour number if the number of days
remailing is below 6.

- I would like the excel file to control the shape's colour based of the
days remaining formula.

I followed microsoft's "Creating the Excel Database and Visio Master"
tutorial at http://support.microsoft.com/kb/254591/en-us and imported tables
and fields from an excel worksheet into Visio. The Visio shape changed colour
and database seemed to be working. I changed and saved the excel file and
tried refreshing the Visio database. Visio displays an error stating: cannot
find linked record in database table for shape "shape name etc". If I revert
and save the excel file, the database doesn't give an error.

I've preformed the following steps:

- In a drawing (.vsd), click on shape
- Tools/Add-ons/Visio Extras/Database Wizard
- "Link shapes to database records"
- "Shape(s) in a drawing"
- Create Data Source...
- "File Data Source (Machine Independent)"
- "Microsoft Excel Driver (*.xls)
- I select the target excel workbook (tables have beem set in excel file)
- Select created ODBC file
- highlight table
- Select 2 field (shape id and days remaining)
- Choose the desired fields from the database
- Check all events and actions for the shape
- Link Shapesheet cells to database fields (FillForegnd==(number from shape
colour formula)
- accept

Source files:
http://www.danielharrisinc.com/visio2003a.zip

Can someone please help me with this problem?

Thank You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio 2003 Shapes 3
Searching for shapes (Visio 2003) 0
Visio 2003 Pro Shapes 0
Find Visio 2003 Shapes 0
Duplicating shapes in Visio 2003 3
ODBC with Excel in 2003 18
Visio Shapes 0
Visio Shapes 0

Top