How to Use Microsoft Excel 2003 With Vb.Net

1. Open VB.Net. Click 'File,' 'Open' and browse to your VB.Net project. Double-click the project file to open it.
2. Click the 'Project' link from the 'Tools' menu. Click 'References.' Check the box next to 'Microsoft Excel Object Library.' Click 'OK.'
3. Click 'Caption.' In the 'General Declaration' window type the following code:Option ExplicitPrivate appExcel As Excel.ApplicationPrivate wBook As WorkbookPrivate mySheet As WorksheetReplace mySheet with the name of your own Excel spreadsheet.
4. Click 'File,' 'Save' to confirm the changes you have made to Excel.