Please Note that I have changed address
Go to
Baking Ways / Productive Bytes

Search This Blog


Saturday, January 7, 2012

New blog address


Please note that I have split my old blog argurosblog in two parts.
I have noticed that looking at some computer programming code with the next post being about a pasta or rice dish was not working very well.

This is my blog about computing
Arguros Computing

This is my blog about cooking
Arguros Cooking

I left this blog on the web because google has already indexed it and you might not have found anymore a live link in case you searched by blog using the search engine.

I hope you will enjoy the change

Wednesday, January 4, 2012

Matlab Excel Link from VBA configuration

To create macros that use Excel Link functions, you must first configure Excel to reference the functions from the Excel Link add-in. From the Visual Basic environment pull down the Insert menu and select Module.When the Module page opens, pull down the Tools menu and select References.... In the References window, check the box for EXCLLINK.XLA and click OK. You may have to use Browse to find the EXCLLINK.XLA file.

If you use MLGetMatrix in a macro subroutine, enter MatlabRequest on the line after MLGetMatrix. MatlabRequest initializes internal Excel Link variables and enables MLGetMatrix to function in a subroutine. For example,

Sub Get_RangeA()
  MLGetMatrix "A", "RangeA"

End Sub

Do not include MatlabRequest in a macro function unless the function is called from a subroutine.