Perhaps someone can help me with this topic. I'm trying to create shapes in Excel from RS/Xojo. I'm getting some compatibility problems because not all shapes properties that I use in VBA Excel are being shown in Xojo. For example,
dim xls as new ExcelApplication dim ws as ExcelWorksheet dim so as ExcelShape xls.Visible=true xls.Workbooks.Add ws=xls.Sheets(1) so=ws.Shapes.AddShape(1,0,0,100,100) so.Name="MyShape" so.TextFrame.Characters.Text="Hello world" so.TextFrame.Characters.Font.Size=9 //Font color so.Fill.ForeColor.RGB=RGB(188,105,113) //* Don't works //-->VBA code //so.TextFrame2.TextRange.Font.Fill.ForeColor.RGB=RGB(188,105,113) //Shape backgroung color so.Fill.BackColor.RGB=RGB(188,105,113) //* Don't works //-->VBA code //so.Fill.ForeColor.RGB //Shape border color so.Line.ForeColor.RGB=RGB(254,86,33) //* Don't works so.Fill.Transparency=0.2
The code to change the color or apply some style on the shape don't works. I don't know if this is a Xojo limitation or I must use other complementary code to get my goal.
Does anyone know how is that Xojo works with VBA ? I mean, the integration depend on the VBA library? Or uses directly the Excel objects model ..?
Any suggestion will be appreciated.