slang
06-14-2011, 04:23 AM
I am moving from 2003 to 2007 and it looks like 2007 handles picture objects differently than 2003. I tried to cheat and use the macro recorder but it would not pick up the events at all.:dunno
Is there a different method I should be using or is it possible in 2007?
Thanks again Excel GODS.....:bow:
This is what I used in 2003
ActiveSheet.Pictures.Insert("C:\all retailers\nophoto.jpg").Select
Selection.ShapeRange.ScaleWidth 0.25, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.25, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 80#
Selection.ShapeRange.Width = 80#
Selection.Name = "front"
Is there a different method I should be using or is it possible in 2007?
Thanks again Excel GODS.....:bow:
This is what I used in 2003
ActiveSheet.Pictures.Insert("C:\all retailers\nophoto.jpg").Select
Selection.ShapeRange.ScaleWidth 0.25, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.25, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 80#
Selection.ShapeRange.Width = 80#
Selection.Name = "front"