Using Excel in VS application

  • Thread starter Thread starter jksedge
  • Start date Start date
J

jksedge

Guest
Hi there,

i am trying to load in an excel file, but this does not appear to be working. It will Dim x1App, but it gives a error with "x1App/Workbooks.Open", indicating that Workbooks is not a member of Application.

Any idea please.
Jim

Imports Microsoft.Office.Interop.Outlook
Imports Excel = Microsoft.Office.Interop.Excel
Imports Microsoft.Office
Public Class Form1
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
Dim x1App As Excel.Application
x1App.Workbooks.Open("C:\Desktop\SH Project\SH Project\SH Reports\Report.xlsx")
x1App.Range("A1").Activate()

Continue reading...
 
Back
Top