Author: vamshi455 | Posted on: 5/10/2009 10:22:22 PM | Views : 262

 Hi all,
I am writing code which has a function that takes too much time for executing.
Function contains:
Dim oExcel As Object = CreateObject("Excel.Application")
        oExcel.Caption = System.Guid.NewGuid.ToString.ToUpper
        ExcelCaption2003 = oExcel.Caption
        Dim oBook As Object = oExcel.Workbooks.Open(RootDir & "\" & sheetname & ".xls")
        Dim oSheet As Object = oBook.Worksheets(1)
        If oBook.SaveAs(RootDir & "\" & sheetname & ".xlsx", XlFileFormat.xlOpenXMLWorkbook) Then
            If Not oExcel.Workbooks Is Nothing Then
              ...

Go to the complete details ...