To copy data from excel in to datagrid in vb6.0

[reshma khan f]

Hi All,

I m using Escel in VB6 .In that i want to copy datas from excel to datagrid.Not all datas but the selected one so that other can easily follow up.
Note that m using ADODB connection in my project


Kindly help me out as soon as possible!

[kadghar]

Hi All,

I m using Escel in VB6 .In that i want to copy datas from excel to datagrid.Not all datas but the selected one so that other can easily follow up.
Note that m using ADODB connection in my project


Kindly help me out as soon as possible!

Remember you can manage Excel's cells as strings, and if you asign an Excel range to a Variant, that variant will become an array.

so if you do something like

[CODE=vb]dim a
a = selection[/CODE]

'a' will be then an 'easy to work with' array.

HTH