Results 1 to 5 of 5

Thread: Re-size and Position Image in Excel worksheet

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    Re-size and Position Image in Excel worksheet

    Hi All, i try to re-size and position as you can see in attachment and code below but all my trying failed. please any suggest to do that? Appreciate your help and your time here. Thank you.
    Code:
     Dim picture As Object
     Dim strURL1 As String
     strURL1 = RS("dt_Image")
     Set picture = xlSheet1.Pictures.Insert(strURL1)
                 picture.ShapeRange.Width = picture.Width
                 picture.ShapeRange.Height = 0.2 * picture.Height
                 picture.Left = 100
                 picture.Top = 20
    Attached Images Attached Images  

  2. #2
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,418

    Re: Re-size and Position Image in Excel worksheet

    Ok, nothing to do with the thread/question, but is this excel-version really going from right to left? Never seen something like it :-)
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  3. #3
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    Re: Re-size and Position Image in Excel worksheet

    Brss

    When you say all attempts "failed", what do you mean?
    ,, picture goes to wrong place
    ,, no picture appears
    ,, something else

    BTW, is this an Excel macro or something in VB6?

    Spoo

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    Re: Re-size and Position Image in Excel worksheet

    Hello and thank you for your reply s. What i mean my tring failed to re-size and position Image as you can see in Post #1. I can insert picture to excel but i cannot re-size and position to place it want. Also, this is vb6 not micro. Thank you

  5. #5
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,418

    Re: Re-size and Position Image in Excel worksheet

    OK, this one has to do with the Topic.

    Have you tried the AddPicture-Method of the Shapes-Collection?
    http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width