Excel file locked for editing

[robertybob]

Hi,

I am making use of an Excel file in a form via the following process (edited for brevity).

Imports Excel = Microsoft.Office.Interop.Excel
Imports Microsoft.Office
xlApp = New Excel.Application
xlApp = CreateObject("Excel.Application")
xlWorkBook = xlApp.Workbooks.Open(....)

When the form is disposed the following code should, I thought, release the file.

xlApp.Quit()
releaseObject(xlApp)
releaseObject(xlWorkBook)

However when I try to open the xlsm file in MS Excel it tells me that it is locked and read-only.

Where am I going wrong with releasing the file when the form closes?

Thanks

[robertybob]

I've now added the following line to the closing process but still cant get access to the xlsm file after form closed.

If Not xlWorkBook Is Nothing Then xlWorkBook.Close()