Make Transparent Textbox in OLE2 Excel

[JabirAmirkhanli]

Hi guys.

I am creating excel by using OLE2 and i want to make TextBox transparent. I have used a lot of method and properties but they were useless.

I hope there is a way to handle it.

[Sandra_Rossi]

If you can't do it manually with Excel, I don't see why you could do it programatically!

But if you can do it manually, then you have the Excel macro recorder.

[JabirAmirkhanli]

Sanra Rossi, You are right, we can do it by recording macro and my macros is following code.

But my attempts to convert this code to ABAP are unsuccessful.

Can you help me ?

**************************MACROS************************

With Selection.ShapeRange.Fill

.Visible = msoTrue

.ForeColor.ObjectThemeColor = msoThemeColorLight1

.ForeColor.TintAndShade = 0

.ForeColor.Brightness = 0

.Transparency = 1

.Solid

End With

Selection.ShapeRange.Line.Visible = msoFalse