excel 2003 and VB.NET

[Maileen]

Hi,

for several years i used the following code without any trouble. But it
seems that under VB.NET and with Excel 11 COM, it has some issues.

here is the code :
Public xlApp As Excel.Application
Public xlWB As Excel.Workbook
Public xlWS As Excel.Worksheet

'-----------------------------------------
' OpenXLSFile
'-----------------------------------------
Public Function OpenXLSFile(ByVal ExcelFile As String)
xlApp = New Excel.Application
xlApp.Visible = True
xlWB = xlApp.Workbooks.Open(ExcelFile)
...
xlWB.Close()
xlWB = Nothing
xlApp.Quit()
xlApp = Nothing
End Function

problem occue on Open function.
does anyone know why ?
i've never seen that.
thanks a lot,

Maileen

 

[Bernie Yaeger]

Hi Maileen,

What is the error you run into?

Bernie Yaeger