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!

