I want to write a function in VBA which uses data of an Excel sheet and evaluate a function in MATLAB with this data as input parameter. Afterwords the evaluated result should be returned back to Excel into a specific cell. I found the functions in the documentation, but not a simple step by step example of what I have to do.
MATLAB: How to write a function in VBA which uses data of cells in Excel, work with this data in MATLAB and return a value to Excel
exampleexcelexcllink.xlalinkSpreadsheet Linkvba
Related Question
- How to rename a sheet in Excel using the COM interface in MATLAB
- How to create chart objects in Excel from MATLAB 7.8 (R2008a)
- Do I get excllink.xla error when I try to load the MS Excel data into Spreadsheet Link EX 3.0.2 (R2008b)
- Color the particular row of the excel sheet
- How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)
- Isn’t the data sent to Excel when I use MLGetMatrix in a macro
Best Answer