You do not need to use VSTO...You will however have to make a project level reference to the Excel Library (which means you will and your application users will have to have excel installed on thier machine)
Hopefully this will get you started:
Imports Excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim XL As New Excel.Application
XL.Visible = True
XL.WindowState = Excel.XlWindowState.xlMaximized
Dim XLWB As Excel.Workbook = XL.Workbooks.Open("C:\Myworkbook.xls")
Dim xlSh As Excel.Worksheet = CType(XLWB.Worksheets(1), Excel.Worksheet)
....
End Sub
|