I'm using .NET3.0 and office 2007. I got the error while creating excel. When I run the code VS-IDE it is working fine. When I hook-up the code with IIS. I am getting the error "Exception has been thrown by the target of an
invocation " . I'm getting the error in InvokeMethod.
Dim obooks As Object = oexcel.Workbooks
Dim ci As System.Globalization.CultureInfo = New System.Globalization.CultureInfo("en-US")
Dim xlWorkBook As Excel.Workbook = obooks.GetType().InvokeMember("Add", Reflection.BindingFlags.InvokeMethod, Nothing, obooks, Nothing, ci)
Dim xlWorkSheet As Excel.Worksheet
Dim FileName As String
Dim fullpath As String
Dim spath As String
Can any one help me on out in this.
Thanks in Advance
View Complete Post