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...
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...