No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
hi, I open a Existing excel sheet and do something and then want to close this excel sheet and open a new excel sheet and work on it. Code:manip.vb OpenFileDialog1.Filter = "Excel files (*.xls)|*.xls" If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then ExcelDoc = New ExcelEx(OpenFileDialog1.FileName) Else Exit Sub End If ExcelDoc.close() GC.Collect() …
hi, I open a Existing excel sheet and do something and then want to close this excel sheet and open a new excel sheet and work on it. Code:manip.vb OpenFileDialog1.Filter = "Excel files (*.xls)|*.xls" If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then ExcelDoc = New ExcelEx(OpenFileDialog1.FileName) Else Exit Sub End If ExcelDoc.close() GC.Collect() …
hi i m getting the error "Operation is not allowed when the object is closed".Why am i getting the error??Plz help Code: [code] Set rs_Temp= Server.CreateObject("ADODB.Recordset") Set Cmd = Server.CreateObject("ADODB.Command") Cmd.ActiveConnection = lcn_Temp Cmd.CommandType = adCmdStoredProc Cmd.CommandText = "sp_temp" Cmd.Parameters.Append Cmd.CreateParameter("@strCurrDate", adVarChar, adParamInput,100, CurrEndDate) rs_Temp.CursorLocation = 3 rs_Temp.Open Cmd[/code]
The End.