Hello -
I receive the error message:
System.Runtime.InteropServices.COMException: The remote procedure call failed.
when I open an Excel file using from an ASP.Net page.
Imports Microsoft.Office.Interop
Imports System.Runtime.InteropServices.Marshal
Public Sub LoadData()
Dim oExcel As New Excel.Application()
Dim oBooks As Excel.Workbooks
oBooks = oExcel.Workbooks
oBooks.Open("C:\ReserveDB\Excel\myfile.xls") '***** Error Message Here ****
Its interesting, the file opens without problem until I add a module to the
Excel workbook "myfile.xls". When the module is added the the error message
happens.
Suggestions?
Thank You, Mark