How can i generate a bas file from compiler that return all the value

Hi,

I am currently using the compiler to create a library of function to be used in excel. This library will be updated from time to time (adding new functions, improving, old one etc...). In this library i have functions that returns multiple outputs. When the bas file is generated, by default, the function returns the first output value. You must modify it in order to have it returning all the output from the function. I am wondering if there is any way to have matlab create the bas file that returns all the value automaticly so i don't have to modify all the functions when recompiling after the updates

Answer 1

[Mudambi Srivatsa]

The following links might be helpful in this case:

https://www.mathworks.com/matlabcentral/answers/98519-is-it-possible-to-use-a-function-that-has-multiple-output-variables-in-excel-builder

https://www.mathworks.com/matlabcentral/answers/92608-how-do-i-return-multiple-arguments-from-a-matlab-excel-builder-add-in-function

[Charles Leblanc]

I actually want a way to modify the code via matlab directly so i don't have to bother doing the modifications for all the functions when i'm updating my function library and recompiling it