View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Inser picture problem

Yes that is correct, in 2007 it not work like in 2003

This will work in 2003 and 2007

Dim myPict As Picture

With ActiveSheet.Range("J10")
Set myPict = .Parent.Pictures.Insert(lcLogoName)
myPict.Top = .Top
myPict.Left = .Left
myPict.Placement = xlMoveAndSize
End With



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lincoln Burrows" wrote in message ...
Hi,
I have a VFP coding for inserting a Picture to the active work book

loExcelSession.Cells(10,10).Select
loExcelSession.ActiveSheet.Pictures.Insert(lcLogoN ame).Select

In Excel 2007 the picture is not inserted in to correct cell what I
mentioned
But in Excel 2003 there is no any problem like that it is inserted in to
correct cell what I mentioned.
Why does this happens
Pls Help