Problems exporting reports to Excel

Question

I am using AccountRight AU 2020.3.1.&nbsp; I have just started to excperience a problem wit exporting reports to Excel (using Office 365).&nbsp; This feature was working fine last week but I now get no response when I go to export any reports to Excel.&nbsp; Similar with PDF although this saves the file to a folder and I can retrieve it through a PDF viwer.&nbsp; I have tried sending by email but this also errors (See attached screenshot).&nbsp; Any suggestions would be appreciated.

komal_s · Accepted Answer

Hi&nbsp;Sadams&nbsp;
&nbsp;
The error log mentions this specific error, "&nbsp;System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop"
&nbsp;
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&nbsp;range of these errors can be fixed by one of the following:
&nbsp;
1. Quick Repair office. (any missing files should be added back)
2. Check/Fix&nbsp;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-...
&nbsp;
Feel free to post should you have any other queries.

sadams · Answer

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

komal_s · Answer

Hi&nbsp;Sadams&nbsp;
&nbsp;
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 · Answer

AccountRight Application Error Report=====================================Application Version: 2020.3.24.318Application File Version: 2020.3.24.1678Incident Id: 7c513db5-7e10-42e9-b1ce-b39175ff0e49Time: Monday, December 7, 2020 5:40:12 AMCode:System.InvalidCastExceptionMessage: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&amp; ppTarget, Boolean&amp; 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) +0xf4at Huxley.UI.Controllers!0x060024de!MYOB.Huxley.UI.Controllers.Helpers.EmailHelper.SendMessage(String to, String subject, String body, EmailResourceType resourceType, String documentNumber, IEnumerable`1 attachments) +0x0at Huxley.UI.Forms!0x06003efd!MYOB.Huxley.UI.Forms.Cards.CardEmail.&lt;&gt;c__DisplayClass6_0.&lt;OnOkClicked&gt;b__1() +0x15at Huxley.UI.Forms!0x06002f5f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.PerformAction(Action methodToPerform) +0x16at Huxley.UI.Forms!0x06001ddb!MYOB.Huxley.UI.Forms.Cards.CardEmail.OnOkClicked(ButtonClickedArgs args) +0xcaat Huxley.UI.Forms!0x06002c45!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.CallButtonClicked(Action`1 execute, ButtonClickedArgs args, String buttonText) +0x12at Huxley.UI.Forms!0x06002bbf!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.btnOk_Click(Object sender, EventArgs e) +0x30at System.Windows.Forms!0x06000e16!System.Windows.Forms.Control.OnClick(EventArgs e) +0x19at DevExpress.XtraEditors.v17.1!0x06000d4f!DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e) +0x2eat DevExpress.XtraEditors.v17.1!0x06000d48!DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) +0x1dat System.Windows.Forms!0x06000efd!System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons button, Int32 clicks) +0x184at System.Windows.Forms!0x06000f0d!System.Windows.Forms.Control.WndProc(Message&amp; m) +0x49fat DevExpress.Utils.v17.1!0x06002708!DevExpress.Utils.Controls.ControlBase.WndProc(Message&amp; m) +0x2eat DevExpress.XtraEditors.v17.1!0x06000256!DevExpress.XtraEditors.BaseControl.WndProc(Message&amp; msg) +0x0at System.Windows.Forms!0x0600571b!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m) +0x0at System.Windows.Forms!0x0600571e!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m) +0x8eat System.Windows.Forms!0x06002deb!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25==========MODULE: DevExpress.Utils.v17.1 =&gt; DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1MODULE: DevExpress.XtraEditors.v17.1 =&gt; DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1MODULE: Huxley.MsOffice.Integration =&gt; Huxley.MsOffice.Integration, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:45807b1f8b88416e9509d3e2e9202202; A:1MODULE: Huxley.UI.Controllers =&gt; Huxley.UI.Controllers, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:a088d0c294f548b99b7dbaf81e7c3498; A:1MODULE: Huxley.UI.Forms =&gt; Huxley.UI.Forms, Version=2020.3.24.318, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:3fd1a8442312472b80a6f5c520e84cda; A:1MODULE: Microsoft.Office.Interop.Outlook =&gt; Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c;MODULE: mscorlib =&gt; mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:f8bf46ea6bc64b5092c28343c64b72a8; A:2MODULE: System.Windows.Forms =&gt; System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:c643f8c6b47f4807860bf3c099806bf8; A:1----------------------------------------&nbsp;&nbsp;

Forum Discussion

Problems exporting reports to Excel

4 Replies

Related content

Unable to Export Reports to Excel

Exporting report to Excel

Exporting Report to Excel

Export Reports to Excel

Can't export reports to Excel

EXPORTING SALES REPORT TO EXCEL

Export display for sales reports

Customer history export/report