February 7th, 2011, 02:20 PM
Editing excel with VB
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
strFileName = OpenFileDialog1.FileName
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!
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a Codeguru.com survey!