XlCall.Excel... type of calls

[Slev]

Hi,

I wonder whether there is a manual or reference available on
XlCall.Excel... type of calls. I need to insert comments to the Excel
cells etc.

Slev

The code below has been copied from
http://excel-dna.net/2011/01/30/resizing-excel-udf-result-arrays/
--------------------------------------------------
XlCall.Excel(XlCall.xlcWorkbookSelect, new object[] {firstCellSheet});
object oldSelectionOnArraySheet = XlCall.Excel(XlCall.xlfSelection);
XlCall.Excel(XlCall.xlcFormulaGoto, firstCell);
XlCall.Excel(XlCall.xlcSelectSpecial, 6);
ExcelReference oldArray =
(ExcelReference)XlCall.Excel(XlCall.xlfSelection);

[Govert van Drimmelen]

Hi Slev,

You can download the official help file (XLMACR8.HLP) for the Excel
Macro language from here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24039
or here: http://www.microsoft.com/download/en/details.aspx?id=9253.

The translation from the Macros to XlCall.Excel(XlCall.xlc....) is
normally easy.

Some of the functions (like xlSheetNm) are documented in the Excel
SDK, which has online documentation here: http://msdn.microsoft.com/en-us/library/bb687883.aspx.

And you are welcome to ask here if you have any specific questions.

-Govert

On Dec 23, 1:00 am, Slev <sulev.p...@gmail.com> wrote:
> Hi,
>
> I wonder whether there is a manual or reference available on
> XlCall.Excel... type of calls. I need to insert comments to the Excel
> cells etc.
>
> Slev
>

> The code below has been copied fromhttp://excel-dna.net/2011/01/30/resizing-excel-udf-result-arrays/