How to find documentation on VBA COM object EXEL i?

Question

1C

Good afternoon, help me find normal documentation, to COMObject("Excel.Application") , how to access certain things, there are a lot of help sites where simple things are described, like these tyk tygdyk , sometimes you can guess by the method of typing what is said in a brief documentation of one from the links, the data type is not specified, the data range is not specified, it turned out to guess by counting the number of data in the Excel itself, I'm talking about painting the cell borders, but about other things, not everything is so user friendly. There is a default documentation for VBA microsoft , but it didn’t help much, it describes the constants that are needed to set the value, but 1C is not aware of them, although methods and properties are available, but the constants are not. How to be.

Answer 1

Formatting cells I found it so far that it is very strange that the horizontal alignment is set by the number 3 when it is the position in Excel at number 2. Microsoft.Office.Tools.Excel generally specifies something not utter, that even linking to a link to a com request does not give result and 1C does not know any such constants. And the color is also set according to the RGB system, not by default, but through a numeric type, analogous to int , according to the formula ((B*256) + G) * 256 + R