I need to use VBA to get Matlab calculations into Excel; I have the Excel
link but not the Excel builder for Matlab.

Many Thanks

Use:

MLGetMatrix "matlab_variable", "A1"
matlabrequest


Mangesh




"James" wrote in message
...
I need to use VBA to get Matlab calculations into Excel; I have the Excel
link but not the Excel builder for Matlab.

Many Thanks

"Mangesh Yadav" wrote:

Use:

MLGetMatrix "matlab_variable", "A1"
matlabrequest


Mangesh




"James" wrote in message
...
I need to use VBA to get Matlab calculations into Excel; I have the Excel
link but not the Excel builder for Matlab.

Many Thanks


Sir, You are a gentleman!

Thank You Very Much

Thanks for the feedback. Good it helped you.

Mangesh


Sir, You are a gentleman!

Thank You Very Much



"James" wrote in message
...


"Mangesh Yadav" wrote:

Use:

MLGetMatrix "matlab_variable", "A1"
matlabrequest


Mangesh




"James" wrote in message
...
I need to use VBA to get Matlab calculations into Excel; I have the
Excel
link but not the Excel builder for Matlab.

Many Thanks

Thanks for your help earlier. I now have I second problem. I need to use to
use the MatLab GARCH toolbox to ouput results to excel, the following code
dosn't error but dosn't return the results:


MLPutMatrix "A", Application.Selection
Excllink.MatlabRequest

Excllink.MLEvalString "A = garchfit(A)"
Excllink.MatlabRequest

MLGetMatrix "A", "D3"
Excllink.MatlabRequest

Thanks in advance

Hi James,

my experience tells me that you require the MatlabRequest only gor the
MLGetMatrix. Anyway, that apart, which oart isn't working. Is it the Put
matrix, the evalstring, or the get matrix. Debug step-by-step. Also check if
your matlab path is correct.

Mangesh



"James" wrote in message
...
Thanks for your help earlier. I now have I second problem. I need to use
to
use the MatLab GARCH toolbox to ouput results to excel, the following code
dosn't error but dosn't return the results:


MLPutMatrix "A", Application.Selection
Excllink.MatlabRequest

Excllink.MLEvalString "A = garchfit(A)"
Excllink.MatlabRequest

MLGetMatrix "A", "D3"
Excllink.MatlabRequest

Thanks in advance