Excel Through ActiveX - Command list?

James Delph — Mon, 12 Nov 2007 11:18:24 -0500

Hi,

I'm working with Matlab and I'm trying to automate a
report creation. All suggested builtin functions can't
help me because this report is very non-standart.

Do you know where I can find the command list that
corresponds to Excel?
(i.e: to create a black border around a cell selsction,
the Matlab syntax would be:
        ActivesheetRange.Borders.Weight=2;
        ActivesheetRange.Borders.LineStyle=1;
        ActivesheetRange.Borders.ColorIndex=1;
)

What other commands are available?
Thanks!

Re: Excel Through ActiveX - Command list?

Chris — Tue, 13 Nov 2007 19:11:46 -0500

"James Delph" <ziv_parizat@amat.com> wrote in message
<fh9cq0$l0k$1@fred.mathworks.com>...
> Hi,
>
> I'm working with Matlab and I'm trying to automate a
> report creation. All suggested builtin functions can't
> help me because this report is very non-standart.
>
> Do you know where I can find the command list that
> corresponds to Excel?
> (i.e: to create a black border around a cell selsction,
> the Matlab syntax would be:
> ActivesheetRange.Borders.Weight=2;
> ActivesheetRange.Borders.LineStyle=1;
> ActivesheetRange.Borders.ColorIndex=1;
> )
>
> What other commands are available?
> Thanks!

James,

My standard answer to this type of question is to proto the
commands in excel/vba thru a macro. Then examine the macro
and search VB help to determine the underlying constants.
Then translate the whole bit to matlab syntax.

-Chris

MATLAB Central Newsreader - Excel Through ActiveX - Command list?

Excel Through ActiveX - Command list?

Re: Excel Through ActiveX - Command list?