Use something like this
ActiveSheet.Shapes.AddPicture "C:\Data\Skate.jpg", msoTrue, _
msoFalse, 100, 100, 100, 50
--
Regards Ron de Bruin
http://www.rondebruin.nl
"mjohnson" wrote in message oups.com...
I am trying automate adding a picture to an excel sheet using JScript
(I would imagine the language shouldn't matter that much). After doing
quite a bit of research I tried writing the following code but I get an
error saying that the 'Pictures' collection is null or not an object.
I can't seem to figure out what I should be doing:
var book = new ActiveXObject("OWC10.Spreadsheet");
var sheet = book.Worksheets[1];
var range = sheet.Range("A1");
range.Activate();
sheet.Pictures.Add( PATH_TO_LOGO_BMP );
Any suggestions? thanks for your help!