Embedding a jpeg image to a an excel template using vbscript

Discussion in 'Web Design, HTML And CSS' started by shadowcat2021, Dec 1, 2010.

  1. shadowcat2021

    shadowcat2021 New Member

    Joined:
    Apr 19, 2010
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    0
    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
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice