How import matlab figure in Excel via VBA

Hi, I need to import Matlab figures, generated by a code, into Excel. I'd like to do this via VBA. MLGetFigure permits to import the current figure but in matlab I created 4-5 figure. Which command should I use in VBA?

Thanks

Massimo

[Selva Karna]

u can use xlswrite

Answer 1

[Nirav Sharda]

There are multiple ways to do this. You can save the MATLAB figures as .jpg files and import them in Excel. You can also use the ActiveX Automation client feature of MATLAB and start Excel, then print the figure to clipboard and then insert the clipboard contents in Excel as mentioned in the following MATLAB Answers post.

https://www.mathworks.com/matlabcentral/answers/98976-how-can-i-export-matlab-figures-to-excel-using-excel-link

I hope this helps.

Answer 2

[Massimo Laspia]

thanks