excel spreadsheet tranferred to a data grid

[Brian Delphino]

I need help with code to import a specific sheet into a datagrid. The .xls file is at C:\test.xls. But only need to pull "sheet1" to the grid. I know this is probably a simple task but Im new and stuck here. Thanx for help!!!


Brian

[Brian Delphino]

ANY IDEAS ANYONE?

[jcg2000]

I also want to know...

[RobDog888]

Welcome to the forums.

Have you tried searching yet? I have many many code examples with Excel. Try a search for Excel and posts by me.

[RobDog888]

Seeing how its slow tonight I will write something for you.

Option explicit
'Add a reference to ms excel xx.0 object library
Private sub command1_click()
    dim oApp as excel.application
    dim oWB as excel.workbook
    set oapp = new excel.application
    set owb = oapp.workbooks.open("C:\MyFile.xls")
    'instead of a msgbox place looping code to iterate 
    'through your cell range of data to be entered into your grid.
    Msgbox owb.sheets("Sheet1").Cells(1, 1)
    owb.close
    set owb = nothing
    oapp.quit
    set oapp = nothing
End sub