Cannot Embed excel file with OLE (vb6)

Hi,

I am trying to read an excel file (one *** only) with about 70 lines
and 6 columns of data using OLE. My problem is that I cannot read all
the 70 lines, it stops reading around the line 50 or so. Is anybody
have a clue? Is there missing something in my code? I thought the file
could be corrupt, but I made a new one and I got the same result.

Here is my code

With OLE1
.Delete
.Class = "Excel.Sheet8"
.CreateEmbed "C:\MyFile.xls"
.SizeMode = 0
.Update
End With

I am using VB6 (SP6) and excel 2000.

Thanks
Denis

.