Export image(figure) in excel to JPG file

Hello, all. I have a simple question.

In my xls file, some contents(from A1 to C27) is captured as image(from E1 to G27) using Camera tool in excel.

I want to export this image(from E1 to G27) as JPG file using Matlab command.

I've tried to that through

actxserver('excel.application');
.Sheets.Item(1).Chart(1);
.Chart.Export(File name);

But, it doesn't work because image file by Camera tool is not recognized as chart but simple image.

So, I think I try to another command such as ExportAsFixedFormat or export range into image file so on.. But it doesn't work well.

Is somebody can give me a hint?

Cheers,

Answer 1

[Image Analyst]

Did you record a macro and look at the VBA source code to see what it does?

[JongChun]

Sub Macro1()

Range("B1:AN38").Select

Selection.Copy

ActiveSheet.Shapes.AddShape(, 1114.5, 3.75, 756.75, 756.75).Select

ActiveSheet.Shapes.Range(Array("Picture 5")).Select

Application.CutCopyMode = False

End Sub

But, I am wondering how those VBA code can be converted to Matlab command?

for example, I cannot make commaned as like "Selection.Copy" in VBA.

[Image Analyst]

See attached example where I use some ActiveX commands from MATLAB to control Excel.