Howdy
I am trying to set the colors of a table cell background and font to particular RGB values with this code. But it only sets bright red - see attached! to bits of it. So my question is what is the syntax to set the RGB values of a cell background an the font.:
pptxTableCell = oTable(intCount, intRow + intStart)
intRangeColourRed = Int32.Parse(ColourRow(0).ToString)
intRangeColourGreen = Int32.Parse(ColourRow(1).ToString)
intRangeColourBlue = Int32.Parse(ColourRow(2).ToString)
intFontColourRed = Int32.Parse(ColourRow(3).ToString)
intFontColourGreen = Int32.Parse(ColourRow(4).ToString)
intFontColourBlue = Int32.Parse(ColourRow(5).ToString)
pptxTableCell.FillFormat.FillType = FillTypeEx.Solid
pptxTableCell.FillFormat.SolidFillColor.ColorType = ColorTypeEx.RGBPercentage
pptxTableCell.FillFormat.SolidFillColor.FloatR = CType(intRangeColourRed, Single)
pptxTableCell.FillFormat.SolidFillColor.FloatG = CType(intRangeColourGreen, Single)
pptxTableCell.FillFormat.SolidFillColor.FloatB = CType(intRangeColourBlue, Single)
pptxTableCell.TextFrame.Text = Right(sCurRowVal, Len(sCurRowVal) - 8)
pptxTableCell.TextFrame.Paragraphs(0).Portions(0).FillFormat.FillType = FillTypeEx.Solid
pptxTableCell.TextFrame.Paragraphs(0).Portions(0).FillFormat.SolidFillColor.ColorType = ColorTypeEx.RGBPercentage
pptxTableCell.TextFrame.Paragraphs(0).Portions(0).FillFormat.SolidFillColor.FloatR = CType(intFontColourRed, Single)
pptxTableCell.TextFrame.Paragraphs(0).Portions(0).FillFormat.SolidFillColor.FloatG = CType(intFontColourGreen, Single)
pptxTableCell.TextFrame.Paragraphs(0).Portions(0).FillFormat.SolidFillColor.FloatB = CType(intFontColourBlue, Single)