Hi everyone,

I am trying to write code that will open an excel worksheet that was picked by the user, pick out specific information, and output that information into a chart. So far I have the code to allow the user to choose the excel file they want to use:

#Private Sub openButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles openButton.Click

Dim obj As New Process

OpenFileDialog1.ShowDialog()

strFileName = OpenFileDialog1.FileName

Process.Start(strFileName)

End Sub

Now I need help creating a code to control the excel sheet the user picked, and pick out a specific range of cells. I've heard using ADO is the best way, but I am new to Visual Basic and I don't really understand how to use ADO. Any help would be greatly appreciated!