Describe once that is done you will need to import some of the Excel features into your source code and declare a few instance variables that you can use throughout your code which will include the application, the worksheet and the workbook of the excel project.

Greetings, I need you to create coding on visual basic for the following assignment.

For this particular project you will be tasked with creating a visual studio project where you open an Excel file and attach some of your personal information to sheet 1. (Ex. Name:Marco Tomas, date: April 12, 2016, Class name: Comp 105 BAS, and so on). you will need to edit the Excel file using visual studios visual basic projects and not through modules in excel.

In order to do that, you will need to import some functionality first by going to your project
dropdown menu – Add Reference and select Microsoft Excel xx.0 Object Library

Once that is done you will need to import some of the Excel features into your source code and declare a few instance variables that you can use throughout your code which will include the application, the worksheet and the workbook of the excel project.
Imports Excel = Microsoft.Office.Interop.Excel
Public Class myForm
Dim myApplication As New Excel.Application
Dim myWorkBook As Excel.Workbook
Dim myWorkSheet As Excel.Worksheet
end Class

Button Event Browse: Choosing the excel file to be modified.
You will need to be able to select the file you wish to change from a dialog box that you call on from your own custom form. To do that you will need to use the OpenFileDialog feature.

Method: Load the excel file
myWorkBook = myApplication.Workbooks.Open( * YOUR ADDRESS FROM OPENFILEDIALOG*)
myWorkSheet = myWorkBook.Worksheets(sheet1″)
Method: Populate worksheet
Recall how we modified excel sheets in class, use the following statement to do the same thing.Recall that we are no longer using range or the name of the cell. In a way, you will be treating the worksheet as a 2D array or a grid.
myWorkSheet. Cells(1, 1).Value = Text Value goes here

Method Save
You will need a method to save and exit the excel file you open and modify.

myWorkSheet = Nothing
myWorkBook.Close(SaveChanges:=True)
myApplication.Quit()
myApplication = Nothing

Button Event: Do stuff
You will need a button event to read the file that you have picked from the dialog box, open the excel file, change it, then save it. Basically something to call on all the methods you wrote
except for choosing the excel file (because you need to do that before anything).

Attention, Please note that you are not supposed to upload any files with additional pages (extra instructions) until Administration informs you on the payment receipt.