Over the years I have used this pattern to create a new Excel document,
On this line I get the error shown,Code:Dim objApp As Excel.Application Dim objBook As Excel.Workbook Dim objSheet As Excel.Worksheet objApp = New Excel.Application objBook = objApp.Workbooks.Add() objSheet = CType(objBook.Sheets(1), Excel.Worksheet)
I went back to some applications that I've had for years with the same pattern and they also fail, both in Visual Studio and in the published/installed version.Code:objBook = objApp.Workbooks.Add() ' <<< {"The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))"}
I don't even know where to start and/or I haven't had enough coffee. HELP!




Reply With Quote