Hi All,
I am not sure if this is where I should be posting this but I really need to figure this out and my problem is a little difficult to explain.
I developed a Windows app that connects to a SQL database and then returns a queried result to a datagrid. I then have an option to export the datagrid results (actually the dataset) to Excel (big thanks to previous posts on this site!). Now, everything worked just fine on my pc, but when I gave my app to a coworker (running the same version of Excel, Office 2000) he received this error:
File or assembly name Interop.Excel, or one of its dependencies, was not found.
I researched this and found something reffering me to download and install new Office PIA's, which I stupidly did. Now the app does not even work on my pc.
I am now getting this error (on my pc):
An unhandled exception of type 'System.InvalidCastException' occurred in Asset Reconciliation.exe
Additional information: QueryInterface for interface Excel._Application failed.
Grrrrrrrrr.....I attempted to uninstall the PIA's but no dice. Grrrrrrr
Somebody please help me.
Thank you very much
I am not sure if this is where I should be posting this but I really need to figure this out and my problem is a little difficult to explain.
I developed a Windows app that connects to a SQL database and then returns a queried result to a datagrid. I then have an option to export the datagrid results (actually the dataset) to Excel (big thanks to previous posts on this site!). Now, everything worked just fine on my pc, but when I gave my app to a coworker (running the same version of Excel, Office 2000) he received this error:
File or assembly name Interop.Excel, or one of its dependencies, was not found.
I researched this and found something reffering me to download and install new Office PIA's, which I stupidly did. Now the app does not even work on my pc.
I am now getting this error (on my pc):An unhandled exception of type 'System.InvalidCastException' occurred in Asset Reconciliation.exe
Additional information: QueryInterface for interface Excel._Application failed.
Grrrrrrrrr.....I attempted to uninstall the PIA's but no dice. Grrrrrrr
Somebody please help me.
Thank you very much
