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
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
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
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