Insert picture
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 |
Insert picture
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 |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com