Greetings fellow users and moderators.
I am using interop to write to excel but it seems that my project isn't writing that well into the excel file. I want to change a cell with "N" to "D" but the coding isn't right.
The listbox contains the row number in a string and changes it to integer.Code:ElseIf check = "N" Then xlWorkSheet.Cells(Int(Listnum.Items(numrent2)), 6) = "D" End If
Afterwards, I am not releasing my COM the right way... I've been informed that my release object is wrong.
Code:Try System.Runtime.InteropServices.Marshal.ReleaseComObject(obj) obj = Nothing Catch ex As Exception obj = Nothing Finally GC.Collect() End Try


Reply With Quote
