Hi,

I want to upgrade my vba code from office 2003 to office 2010, i found in Microsoft documentation the removed, changed and deprecated methods and properties, but i cannot find the Alternative methods of "Removed" and "deprecated" methods and properties, for example:

In Word the Property "Color" of "Font" object is deprecated, that mean it will not be supported in office 2013, but i cannot find the alternative of it.

In Excel the method "ApplyCustomType" of "Chart" Object had the same problem.

Hi,

Based on my test, in Word 2010, w can use Font.ColorIndex to set color.

As for Excel code, we can try to record a macro to check what's the difference.