Visio + Excel + VBA + Dynamic

[davulf]

Hi Experts,

I was wondering if there was a way to fill out and save an Excel spreadsheet that contained a table with two columns (Name; Status). Suppose then that we had a diagram in Visio and that each of the shapes within that diagram corresponded to a row in the 'Name' column in our Excel sheet. Is there a way in VBA to execute a macro that will load the values from the Excel sheet, and verify the status (0, 1, 2)?

I would then like to change the colour of the shape based on the status returned.

Please let me know if this is possible.

Thanks,
DaVuLf

 

[smacktalk]

http://msdn.microsoft.com/en-us/lib...cations_BringingDataintoVisiofromOtherSources