Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro 2003 vs 2007
This macros below allowed me to insert a picture that I choose into Cell G1
at the correct heigth and with in 2003. Now in 2007 it does not put it into the cell I want so the placement on the Excel sheet is wrong and I have to drag it to the desired cell. Any Ideas? Sub InsertPicture() Dim myPicture As String, MyObj As Object Range("g1").Select myPicture = Application.GetOpenFilename _ ("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", _ , "Select Picture to Import") If myPicture = "False" Then Exit Sub Set MyObj = ActiveSheet.Pictures.Insert(myPicture) With MyObj With .ShapeRange .LockAspectRatio = msoFalse .Height = 198 .Width = 280 End With .Placement = x1MoveAndSize End With End Sub |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro 2003 vs 2007
Pictures don't go into cells but sits ontop of th eworksheet. You can make a
picture look as if it is in a cell but it is not really in the cell.try these changes Sub InsertPicture() Dim myPicture As String, MyObj As Object myPicture = Application.GetOpenFilename _ ("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", _ , "Select Picture to Import") If myPicture = "False" Then Exit Sub Set MyObj = ActiveSheet.Pictures.Insert(myPicture) With MyObj With .ShapeRange .LockAspectRatio = msoFalse .Left = Range("G1").Left .Top = Range("G1").Top .Height = Range("G1").Height .Width = Range("G1").Width End With End With End Sub "Ron" wrote: This macros below allowed me to insert a picture that I choose into Cell G1 at the correct heigth and with in 2003. Now in 2007 it does not put it into the cell I want so the placement on the Excel sheet is wrong and I have to drag it to the desired cell. Any Ideas? Sub InsertPicture() Dim myPicture As String, MyObj As Object Range("g1").Select myPicture = Application.GetOpenFilename _ ("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", _ , "Select Picture to Import") If myPicture = "False" Then Exit Sub Set MyObj = ActiveSheet.Pictures.Insert(myPicture) With MyObj With .ShapeRange .LockAspectRatio = msoFalse .Height = 198 .Width = 280 End With .Placement = x1MoveAndSize End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 macro generates compiler error on 2007 | Excel Worksheet Functions | |||
Macro for Pivot in MS Excel 2003 vs 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
Place an IF Statement into a Macro 2007 and 2003 | Excel Discussion (Misc queries) |