vb.net访问excel的几个问题！
如题，电脑上的excel版本是office2007 ，引用代码如下
Imports Microsoft.Office.Interop.Excel
Private xlExcel As Application
Dim xlBook As Workbook
Dim xlSheet As Worksheet
xlExcel = CreateObject("Excel.Application")
xlBook = xlExcel.Workbooks.Open(...)
xlSheet = xlBook.Worksheets(1)

然后直接用
xlsheet.range("A1:B1")=.....
就提示range为readonly
当用if xhsheet.cells(..)=xlsheet.cells(...) then
这句又报错,说什么range和range没有定义运算符"="
请高人指教。为什么这些都不能用。到哪错了。谢谢了

[解决办法]
Private xlExcel As Application
将xlExcel这个对象用NEW实例化

Private xlExcel As NEW Application