Hello good people,
I have this beast as an error. Did my research and found some posts here as well but did not do any good for me.
Here is what I did. I had an error regarding issue rights with COM objects so I gave access rights under component services for Microsoft Excel application now I am getting this error.
Here is some information regarding this
1. Gave rights to ASPNET and network service to my web app directory to try to fix this error.
2. The exact same process works on my Windows 2003 server and my Windows 7 development machine. I am trying to get this going on a different windows 2003 machine that is outside of our domain.
3. Developing on windows 7 64 bit with office 2010 installed. Also excel 2010 is installed on my Web server
4. Here is the code that is causing the error: The last line is causing the error.:
MyXl = new Microsoft.Office.Interop.Excel.Application();
MyXl.Visible = false;
MyWb = (Microsoft.Office.Interop.Excel._Workbook)(MyXl.Workbooks.Add(Missing.Value));
int test = 0;
MySheet = (Microsoft.Office.Interop.Excel._Worksheet)MyXl.ActiveSheet;
int InRow = 2;
for (int i = 0; i < Nu
View Complete Post