Hello, I am trying to insert an image to an excel spreadsheet that I have already opened and used. I found a way to do it in a bit more complicated but I wanted to know how I can adjust the size and set the image at a fixed locations for example, there was a vb macro code that I found but I want to use it for vbscript:
Code:
Range("C41:L58").Select
ActiveSheet.Pictures.Insert( _
"Z:\ActivPlant Screenshots\2010\11-10\Red Shift\110110.jpg")
With this I got Type mismatch

If there is any suggestions to do it, anything will help

Thanks in advance