title: VbScript unknown runtime error on opening workbook
body: <p>I'm not able to open any-work while working with QTP using vbscript to open Excel workbook to read input data. History of the problem is as - on last weekend my organization decided to install Excel 2010 on my machine. After that, when i checked i had two version of Excel (2007 &amp; 2010) installed on my machine which started the problem.</p>
  
  <p>I removed excel 2010 and re-install excel 2007 but the problem is still persisting.
  Code which is giving the error is while opening workbook as 'Unknown Runtime Exception'</p>
  
  <pre><code>completeFilePath = "C:\Users\rahul.singh\Desktop\TC1.xls"
  gv_SanityTradeDataSheet = "TCFlow"
  
  Set objExcel = CreateObject("Excel.Application")
  Set objWorkbook = objExcel.WorkBooks.Open(completeFilePath)
  Set objDriverSheet = objWorkbook.Worksheets(gv_SanityTradeDataSheet)
  wscript.echo objDriverSheet.UsedRange.Rows.Count
  
  objWorkbook.Close
  Set objDriverSheet = Nothing
  Set objWorkbook = Nothing
  objExcel.quit
  Set objExcel = Nothing
  </code></pre>
  
  <p>Any idea what's the issue/fault and how to come out of it</p>
  
  <p>Thanks,
  Rahul</p>