active x controls to import excel sheet on to a vb form

[innoc]

I want to have a excel sheet on a vb form..

In excel i use something like a filter option which filters data on criteria suplied by us ,will this be posible in a vb form, if we import a excel sheet.


secondly I couldn't find the proper ActiveX
controls to display the Excel spreadsheet and to
dynamically retreive the selected columns, cells and
the range out of it. There are a couple of OLE
containers, but they just display the excel
spreadsheet in the form. If one clicks on it, it just
opens the linked excel spreadsheet itself. Since my
requirement is just to display the content of
spreadsheet in VB form, they do not seem to be the
appropriate controls.

But there is a slew of "Microsoft Office Web Component
controls" is available. One of them( Spreadsheet
control ) displays the spreadsheet( which is
updateable ) in Web Pages. but with this control i am not able to import the excel sheet directly on to the form

could any one suggest me a way out for this problem..

thanks a million in advance

 

[Foada]

Use the WebBrowser Control to navigate an Excel workbook