Suggestions: Whether we can enable the MLPutMatrix directly send VBA variable/values to matlab?

2 views (last 30 days)
As we know, we can send the value of one cell or the values in one range to Matlab in VBA by calling MLPutMatrix command. e.g.
MLPutMatrix "A", Range("C3")
However, in VBA, sometime we define variable or directly refer to one value of one control, and send the control's or variable's value to matlab. The command MLPutMatrix will fail to do so. e.g.
MLPutMatrix "L2LEDNr", TxtL2LEDNr.Value
Here, TxtL2LEDNr is one text control put on one userform.
Although I can firstly write the "TxtL2LEDNr.Value" to one cell, e.g. "C1", then use the MLPutMatrix to get the value of the cell, e.g.
Cells(1,3).Value=TxtL2LEDNr.Value
MLPutMatrix "L2LEDNr" range("C1")
I'm still wondering whether there is some other ways to do. (Although I =also wrote one subroutine in excel VBA to generalize the work, I still hope Matlab should incorporate the function into the toolbox)
After all, it will be very convenient if we also can overload the MLPutMatrix to enable it directly sends variable/value instead of only range value from excel to Matlab.
Thanks

Answers (0)

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!