Hi All,
I was trying to Automate MS Excel through C#. Everything works fine
until in the development machine(it has VS2005 with Excel 2003 in Vista)
when I deployed my code in a non-development machine(Excel 2003 with XP)
following exception has been thrown.
"Unable to cast COM object of type 'System.__ComObject' to interface type
'Microsoft.Office.Interop.Excel._Application'. This operation failed because
the QueryInterface call on the COM component for the interface with IID
'{000208D5-0000-0000-C000-000000000046}' failed due to the following error:
Library not registered. (Exception from HRESULT: 0x8002801D
(TYPE_E_LIBNOTREGISTERED))."
a. I ve already tried Installlating Office 2003 PIA's.
b. Repaired Office 2003 also.
My Excel references in workspace points to Library in GAC, and "CopyLocal"
property has been set to false.
any workaround to resolve this would be greatly appreciated.
Sample code snippet.
Excel._Application m_oApplication;
Excel.Workbooks m_oWorkBooks;
try-catch
//
m_oApplication = new Excel.Application();
m_oWorkBooks = (Excel.Workbooks)m_oApplication.Workbooks;
Bookmarks