hi, i have a vb6.0 application, and im trying to use an excel sheet to fill a Grid.
i checked the reference to Miscrosoft excel, and im trying to do it like this:
Dim oExcel As Excel.Worksheet
Set oExcel = GetObject("E:\FileName.xls"
but i get an error with incompatible types.. does anybody know what class should i use?
i tried Excel.Application, Excel.WorkBook and none worked..
what i need is to copy by code the sheet to a grid i have on my form.
thank you very much
Eli
i checked the reference to Miscrosoft excel, and im trying to do it like this:
Dim oExcel As Excel.Worksheet
Set oExcel = GetObject("E:\FileName.xls"
but i get an error with incompatible types.. does anybody know what class should i use?
i tried Excel.Application, Excel.WorkBook and none worked..
what i need is to copy by code the sheet to a grid i have on my form.
thank you very much
Eli