Forum Discussion

Sadams's avatar
Sadams
Cover User
4 years ago
Solved

Problems exporting reports to Excel

I am using AccountRight AU 2020.3.1.  I have just started to excperience a problem wit exporting reports to Excel (using Office 365).  This feature was working fine last week but I now get no respons...
  • Komal_S's avatar
    Komal_S
    4 years ago

    Hi Sadams 

     

    The error log mentions this specific error, " System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop"

     

    Generally, this error means that when a program such as AccountRight asks which version of Excel is installed, the wrong version is being reported back, causing a communication problem and errors between the programs.

    This can happen when different versions of Office/Excel may have been previously installed on the computer, and components/values are left behind. A     range of these errors can be fixed by one of the following:

     
    1. Quick Repair office. (any missing files should be added back)

    2. Check/Fix Registry Keys (this step can only be completed by an IT professional as this is an environmental issue with windows having missing or incorrect information). Reference link as an example for Outlook is :

    https://webmakers.co.nz/interface-not-registered-exception-from-hresult-0x80040155-microsoft-office-...

     

    Feel free to post should you have any other queries.

Komal_S's avatar
Komal_S
MYOB Moderator
4 years ago

Hi Sadams 

 

On this error window, if you click on "View error details", it will produce a detailed log containing reasons for why the system is crashing. Can you please attach the log here so we can investigate further and advise accordingly.

  • Sadams's avatar
    Sadams
    Cover User
    4 years ago

    AccountRight Application Error Report
    =====================================
    Application Version: 2020.3.24.318
    Application File Version: 2020.3.24.1678
    Incident Id: 7c513db5-7e10-42e9-b1ce-b39175ff0e49
    Time: Monday, December 7, 2020 5:40:12 AM

    Code:
    System.InvalidCastException


    Message:
    Unable to cast COM object of type 'Microsoft.Office.Interop.Outlook.ApplicationClass' to interface type 'Microsoft.Office.Interop.Outlook._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00063001-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).


    Stack Trace
    ----------------------------------------
    1 : System.InvalidCastException
    ----------------------------------------
    System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Outlook.ApplicationClass' to interface type 'Microsoft.Office.Interop.Outlook._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00063001-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
    at mscorlib!0x06004227!System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
    at Microsoft.Office.Interop.Outlook!0x06002365!Microsoft.Office.Interop.Outlook.ApplicationClass.CreateItem(OlItemType ItemType)
    at Huxley.MsOffice.Integration!0x06000078!MYOB.Huxley.MsOffice.Integration.OutlookEmail.OutlookEmailProvider.SendMessage(String emailAddresses, String subject, String body, EmailResourceType resourceType, String documentNumber, IEnumerable`1 attachments) +0xf4
    at Huxley.UI.Controllers!0x060024de!MYOB.Huxley.UI.Controllers.Helpers.EmailHelper.SendMessage(String to, String subject, String body, EmailResourceType resourceType, String documentNumber, IEnumerable`1 attachments) +0x0
    at Huxley.UI.Forms!0x06003efd!MYOB.Huxley.UI.Forms.Cards.CardEmail.<>c__DisplayClass6_0.<OnOkClicked>b__1() +0x15
    at Huxley.UI.Forms!0x06002f5f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.PerformAction(Action methodToPerform) +0x16
    at Huxley.UI.Forms!0x06001ddb!MYOB.Huxley.UI.Forms.Cards.CardEmail.OnOkClicked(ButtonClickedArgs args) +0xca
    at Huxley.UI.Forms!0x06002c45!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.CallButtonClicked(Action`1 execute, ButtonClickedArgs args, String buttonText) +0x12
    at Huxley.UI.Forms!0x06002bbf!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.btnOk_Click(Object sender, EventArgs e) +0x30
    at System.Windows.Forms!0x06000e16!System.Windows.Forms.Control.OnClick(EventArgs e) +0x19
    at DevExpress.XtraEditors.v17.1!0x06000d4f!DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e) +0x2e
    at DevExpress.XtraEditors.v17.1!0x06000d48!DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) +0x1d
    at System.Windows.Forms!0x06000efd!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x184
    at System.Windows.Forms!0x06000f0d!System.Windows.Forms.Control.WndProc(Message& m) +0x49f
    at DevExpress.Utils.v17.1!0x06002708!DevExpress.Utils.Controls.ControlBase.WndProc(Message& m) +0x2e
    at DevExpress.XtraEditors.v17.1!0x06000256!DevExpress.XtraEditors.BaseControl.WndProc(Message& msg) +0x0
    at System.Windows.Forms!0x0600571b!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
    at System.Windows.Forms!0x0600571e!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8e
    at System.Windows.Forms!0x06002deb!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25
    ==========
    MODULE: DevExpress.Utils.v17.1 => DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1
    MODULE: DevExpress.XtraEditors.v17.1 => DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1
    MODULE: Huxley.MsOffice.Integration => Huxley.MsOffice.Integration, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:45807b1f8b88416e9509d3e2e9202202; A:1
    MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:a088d0c294f548b99b7dbaf81e7c3498; A:1
    MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:3fd1a8442312472b80a6f5c520e84cda; A:1
    MODULE: Microsoft.Office.Interop.Outlook => Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c;
    MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:f8bf46ea6bc64b5092c28343c64b72a8; A:2
    MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:c643f8c6b47f4807860bf3c099806bf8; A:1

    ----------------------------------------

     

     

    • Komal_S's avatar
      Komal_S
      MYOB Moderator
      4 years ago

      Hi Sadams 

       

      The error log mentions this specific error, " System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop"

       

      Generally, this error means that when a program such as AccountRight asks which version of Excel is installed, the wrong version is being reported back, causing a communication problem and errors between the programs.

      This can happen when different versions of Office/Excel may have been previously installed on the computer, and components/values are left behind. A       range of these errors can be fixed by one of the following:

       
      1. Quick Repair office. (any missing files should be added back)

      2. Check/Fix Registry Keys (this step can only be completed by an IT professional as this is an environmental issue with windows having missing or incorrect information). Reference link as an example for Outlook is :

      https://webmakers.co.nz/interface-not-registered-exception-from-hresult-0x80040155-microsoft-office-...

       

      Feel free to post should you have any other queries.

      • Sadams's avatar
        Sadams
        Cover User
        4 years ago

        Komal

         

        Thank you for your assistance.  I have resolved the issue by doing your Quick Repair office proceedure.  At the same time, there was an Office 10 update that I installed.  Excel reports are now being generated from MYOB and I can successfully email reports from MYOB.