I have been finding it difficult to simply refer to an Excel file so that I may immediately copy its contents into a new worksheet.
I understand that this refers to creating a new Excel file and its contents:
//Start Excel and get Application object.
oXL = new Excel.Application();
oXL.Visible = true;
//Get a new workbook.
oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing.Value));
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
However, this is where I become lost.
I want to replicate data from another Excel file into the new worksheet above when the user chooses it through a file dialogue box.