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

"Maileen" <no*****@nospam.com> wrote in message
news:eZ**************@tk2msftngp13.phx.gbl...

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