Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Web Design, HTML And CSS Forums (http://www.go4expert.com/forums/web-design-forum/)
-   -   Embedding a jpeg image to a an excel template using vbscript (http://www.go4expert.com/forums/embedding-jpeg-image-excel-template-t24052/)

shadowcat2021 2Dec2010 02:33

Embedding a jpeg image to a an excel template using vbscript
 
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:D


All times are GMT +5.5. The time now is 09:32.