Error Message Saving Excel Workbook

[Mark]

Hello -

I'm opening/saving an Excel workbook from ASP.Net. When I try to save the
workbook I get the error:
System.Runtime. InteropServices .COMException: The remote procedure call failed.

Code:
Dim oExcel As New Excel.Applicati on()
Dim oBooks As Excel.Workbooks
Dim oBook As Excel.Workbook

oExcel.Visible = True
oExcel.DisplayA lerts = False

'Start a new workbook
oBooks = oExcel.Workbook s
oBooks.Open("c: \test.xls", 0)
oBook = oBooks.Item("te st.xls")
:
:
oBook.SaveAs(sT emplate) '**** Occurs Here *****

oBook.Close()
Suggestions/workarounds?

Thanks, Mark

[David Lloyd]

Mark:

Can't tell for sure from your code, but did you set the value for the
sTemplate variable? If this value isn't set it can cause a COMException.
If it is set, you may want to show more of the code.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Mark" <Ma**@discussio ns.microsoft.co m> wrote in message
news:25******** *************** ***********@mic rosoft.com...
Hello -

I'm opening/saving an Excel workbook from ASP.Net. When I try to save the
workbook I get the error:
System.Runtime. InteropServices .COMException: The remote procedure call
failed.

Code:
Dim oExcel As New Excel.Applicati on()
Dim oBooks As Excel.Workbooks
Dim oBook As Excel.Workbook

oExcel.Visible = True
oExcel.DisplayA lerts = False

'Start a new workbook
oBooks = oExcel.Workbook s
oBooks.Open("c: \test.xls", 0)
oBook = oBooks.Item("te st.xls")
:
:
oBook.SaveAs(sT emplate) '**** Occurs Here *****

oBook.Close()
Suggestions/workarounds?

Thanks, Mark