How to deal with OLE Automation Control With Using ExcelWorkSheet in Visual Basic

Hi,
I am a new user of VBA. I want to open excelsheet in visual basic where I can put my databse information. I am trying to put these informations through OLE control by selecting ExcelWorksheet as an option. But the behaviour of this informations are not as per my expectations. I have following questions.

(1). I have to show my ExcelWorksheet in visual basic form only and NOT by opening new Excel Sheet. How to put my database informations in ExcelWorksheet ( in visual basic form ) by using Visual Basic OLE Control.
(2). If informations are very huge than how to show horizontal and vertical scroll bar in the excelsheet in visual basic form.
(3). How to edit cells in excelsheet in visual basic form.
(4). How to show charts in visualbasic form by using excelcharts.
(5). How to put values in ExcelSheet cell by cell instead of putting entire informations at one shot.

If possible than please provide me samples code of my above questions. Please provide any useful links if you knows about using excelsheet in visualbasic form.
Please goes through the following link which I am trying to use as an OLE ExcelWorkSheet example.
Link :: URL

Moreover, I am using VisualBasic 2000 and Excel 2000.

Thank you very much in advance for your nice coopeartions.

Regards,
Pragnesh.