I'm creating a xl worksheet i VB6 using the following code.
i close these in this manner.Code:Public objXL As New Excel.Application Public wbXL As New Excel.Workbook Public wsXL As New Excel.Worksheet Set wbXL = Workbooks.Open(App.Path & "\test.xls") Set wsXL = wbXL.Worksheets.Add(, Worksheets(1))
After executing above code, when i open the task manager there still is an instance of xl process in memory.Code:wbXL.Save Set wsXL = Nothing wbXL.Close False Set wbXL = Nothing Set objXL = Nothing
i hv win xp, vb6 SP5 , office2k. can any1 help
-amresh-





Reply With Quote