I have an excel file that I want to update a cells data then save the file anc exit out of the excel application. It seems to work ok except when it comes to closing the excel application. It seems to keep the excel file locked this is the code I have to open/close the file
Dim app As New Excel.Application
app.Workbooks.Open "test.xls"
app.Range("A1").Select
ActiveCell.Offset(0, 0).Value = Date
ActiveWorkbook.Save
app.Workbooks.Close
app.Quit
Anyone know what I am doing wrong.
Dim app As New Excel.Application
app.Workbooks.Open "test.xls"
app.Range("A1").Select
ActiveCell.Offset(0, 0).Value = Date
ActiveWorkbook.Save
app.Workbooks.Close
app.Quit
Anyone know what I am doing wrong.