i know this is a big problem for a lot of people and there are posts everywhere... but they aren't helping lol.
below, should this complete and close and terminate excel correctly? or am i missing something...
Code:oExcel = CreateObject("Excel.Application") oBooks = oExcel.Workbooks oBook = oBooks.Open(Filename:="C:\Jared FC Project Desktop\fixture tracking.xls", UpdateLinks:=False, ReadOnly:=False) oSheet = oBook.Worksheets(1) oExcel.Visible = True oSheet = Nothing oBook.Close() oBook = Nothing oBooks.Close() oBooks = Nothing oExcel.Quit() oExcel = Nothing




Reply With Quote