i want to insert picture from disk to excel using visual basic 6. i've use
following code:

dim oApp As New Excel.Application
dim oWkbk As Excel.Workbook
dim oSheet As Excel.Worksheet

ActiveCell.Range("A100").Activate
ActiveSheet.Pictures.Insert ("C:\TEMP.BMP")

the problem is, the picture is to large and i want to insert that picture
only from cell A100 to E120.
which function i should use?

any help would be greatly appreciate..
thanks