Connection Between VB6.0 and Excel

[chitragovardhan]

I would like to know the steps in detail about how to establish the connection between VB6.0 and Excel.

ITS VERY URGENT

[debasisdas]

Try to use the Data control.

[kadghar]

I would like to know the steps in detail about how to establish the connection between VB6.0 and Excel.

ITS VERY URGENT

Sure, open an excel application, and use any command allowed in VBA for excel. e.g:

[CODE=vb]dim obj1 as object
set obj1 = createobject("e xcel.applicatio n")
obj1.workbooks. open("c:\mybook .xls")
msgbox obj1.activework sheet.cells(1,1 ).value[/CODE]

HTH

PS: sorry for the late answer, but you posted the question when it was 3am in Mx.