Replace :
SaveExcel()
oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open(FileLocation & FileName)
oBook = oExcel.ActiveWorkbook
oSheet.Range("A1").Value = "TEST"
With:
SaveExcel()
oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open(FileLocation & FileName)
oBook = oExcel.ActiveWorkbook
oSheet = oExcel.Worksheets(1)
oSheet.Range("A1").Value = "TEST"
Be mysterious, be unavailable, they'll want you more.
ReplyDeleteSee the link below for more info.
#unavailable
www.ufgop.org