Incompatibility between win98 and Excel2000 via VB6

[CortexWayne]

Hi! Here is my little problem. I have built a program that read Excel sheet to update his price list. So my program is done in VB6 programmed on a win2k with office 2000. When I run my program on a win 98 win office 2000. He is abble to open my Excell workbook with this:

Set myExcel = New Excel.Application (this work)
myExcel.Workbooks.Open PathExcel (this work)
myExcel.Application.Visible = True (this work)


And then I try to reach my worksheet and everythings just don't want to go well

IN WIN2K:
myExcel.Workbooks.Count
give me the result '1'
myExcel.Workbooks(1).Worksheets.Count
give me the result '1'

IN WIN98:
myExcel.Workbooks.Count
give me the result '1'
myExcel.Workbooks(1).Worksheets.Count
give me the result '0'

My program crash and shut down whith an error without signification when I try:
myExcel.Workbooks(1).Worksheets(1).cells(1,1) = 'Anything'

So when I'm in win98, I'm able to open the Excel 2000 workbooks but unable to access data in the sheet or the sheet it self.

Any help, hint, comments are welcome

Martin Lamontagne
Programmer
CortexWayne@hotmail.com

http://www.FirebladeExperiment.com