[RESOLVED] Release resources of excel
In vb6 application i have imported data from excel sheet by creating excel application. After the application excel resources are not released and it is not opening even after following code i have used at the end of the application.
Set xl = Nothing
Set xlwbook = Nothing
Set xlSheet = Nothing
Re: Release resources of excel
before setting to nothing, you must close your workbook and quit your application
Re: Release resources of excel
it is working,but is it enough only xlwbook is closed or any other should be closed.Anyway thanks for helping.
Re: Release resources of excel
There is a tutorial by si_the_geek as to how to open and close, release memory. See my signature.