Found this on Google[
^]
Dim xlApp As Excel.Application
Dim wb As Workbook
Dim ws As Worksheet
Dim var As Variant
Set xlApp = New Excel.Application
Set wb = xlApp.Workbooks.Open("PATH TO YOUR EXCEL FILE")
Set ws = wb.Worksheets("Sheet1")
var = ws.Range("A1").Value
var = ws.Cells(1, 1).Value
ws.Cells(1, 1).Value = "Sample Text"
wb.Close
xlApp.Save
xlApp.Quit
Set ws = Nothing
Set wb = Nothing
Set xlApp = Nothing
Just add a reference
Microsoft Excel Object Library