For the visual folks:
And at line 61:
Everything I'm finding on the web is one of 3 solutions for the problem:
- The user is trying to use an interop assembly without Excel installed. I have M$ office pro 2010 installed. So that's not the issue.
- I'm not typing it out but you can look here
- Users are running the interop assembly in 64-bit, I'm on a 32 bit machine. So that's unrelated. But I did try compiling as 32bit only instead of Any CPU. Didn't help.
Basically fix #2 is for those running this code on a server and their code is executing under the ASP user account, in my case its a desktop app so this should be unrelated but in desperation I added "Everyone" to the permissions and gave them all privileges. Didn't work.
So now I'm turning to here. Any questions, comments, concerns?