Link Excel cell color to Visio shape color

F

FatMan

I have linked excel and Visio.

There is no problem sharing the cell values but I can't link the cell color.

value -

Visio.ActiveWindow.Page.Shapes.ItemFromID(a).Text = xlSheet.Cells(1 + a,
5).Value

Color -

Visio.ActiveWindow.Page.Shapes.ItemFromID(PIN_COUNTER).CellsSRC(visSectionObject,
visRowFill, visFillForegnd).FormulaU = xlSheet.Cells(1 + PIN_COUNTER,
4).forecolor

Any suggestions ?
 

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

Match table shading (color) to Visio color/Transparency 1
How to determine the itemfromID to change colors 3
Visio shape text disappears upon copy paste 1
Need Help with Grid Origin Macro I wrote 3
Visio 2010 Programmatically change Shape fill color using C# 0
changing colours of Visio shapes 2
Word macro that can call cells out of Excel for a find and replace 0
Cisco stencils: add text Handler 0

Top