Excel Character object through COM

[Krisz]

Hi!

Maybe this question is already answared somewhere, but I could not find
it:

I want to modify one of the letters of a text of a Excel cell through
COM; let's say to make it red. The VB reference tells that it can be
managed with:

With Worksheets("Sheet1").Range("A1")
.Value = "abcdefg"
.Characters(3, 1).Font.Bold = True
End With

However when I try the similar in Python (I used the 'COM Makepy
utility' of Pythonwin) I got the following (Here 'A' is a class that
wraps the 'com' things):
<win32com.gen_py.Microsoft Excel 9.0 Object Library.Characters instance
at 0x19420904>
Traceback (most recent call last):
File "<interactive input>", line 1, in ?
AttributeError: Characters instance has no __call__ method

So my question is that am I doing something wrong or there is a
different way to modify the color of a charater through COM.

Thank you.
Regards, Krisztian

 

[Max Erickson]

Traceback (most recent call last):
File "<interactive input>", line 1, in ?
AttributeError: Characters instance has no __call__ method

So my question is that am I doing something wrong or there is a
different way to modify the color of a charater through COM.

try GetCharacters(1,1)

max

 

[Krisz]

Thanks, it works...

Krisz