Hi,

I have to insert a picture into an excel 2000 worksheet within MATLAB R14,
using COM-commands.
I very new to it, the commmands that worked so far to insert text a

Excel = actxserver('Excel.Application');
%% open document (omitted), then
Activesheet = Excel.Activesheet;
....
Activesheet.Range(['A6']).Value = 'testvalue';

No I'm searching for the right object, method or property to insert a
picture, stored in a file (preferably) or in the clipboard.

I tried:

Activesheet.Range('A25').Select;
pic = Activesheet.Pictures.Insert('C:\mypic.tiff').Selec t

But I get the error message:
"No appropriate method or public field Pictures for class
Interface.Microsoft_Excel_9.0_Object_Library._Work sheet."

Dou you have any suggestions??
Thanks,
Cannabibal

Try searching for words like
catalog picture*

If it really is for a catalog, I'd suspect that Word would be better. There
have also been postings involving Access.

Merge Pictures and Words - Oh My!, by Cindy Meister, creates a catalog from text wording and external pictures from an Excel
database. [photos, photographs] Also see extracting JPG / GIF files
[-- file:///C:/copiedsite/dmcritchie/excel/xl2gif.htm --] from an Excel document (charts).
http://www.computorcompanion.com/LMMArticle.asp?ID=126
Computer Companion, E-zine article

Linking to Photos
[-- http://groups.google.com/groups?as_u...ontextures.com --], Debra Dalgleish (short posting), similar,
less explanation.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Cannabibal" wrote in message ...
Come on, there must be somebody here who has a hint or comment...

Cannabibal


"Cannabibal" wrote:

Hi,

I have to insert a picture into an excel 2000 worksheet within MATLAB R14,
using COM-commands.
I very new to it, the commmands that worked so far to insert text a

Excel = actxserver('Excel.Application');
%% open document (omitted), then
Activesheet = Excel.Activesheet;
...
Activesheet.Range(['A6']).Value = 'testvalue';

No I'm searching for the right object, method or property to insert a
picture, stored in a file (preferably) or in the clipboard.

I tried:

Activesheet.Range('A25').Select;
pic = Activesheet.Pictures.Insert('C:\mypic.tiff').Selec t

But I get the error message:
"No appropriate method or public field Pictures for class
Interface.Microsoft_Excel_9.0_Object_Library._Work sheet."

Dou you have any suggestions??
Thanks,
Cannabibal