Forum Discussion

6203's avatar
6203
Experienced Cover User
2 years ago
Solved

Can't export reports to Excel

I am using AccountRight Plus AU 2022.11.0, on my desktop.   I cannot export my reports to Excel.   Any suggestions?  (Seems to be a fairly recent problem, as I could export not that long ago.)  ...
  • Melisa_D's avatar
    Melisa_D
    2 years ago

    Hi 6203, 

     

    Looking at the error log I can see that you are experiencing the Microsoft.Office.Interop.Excel._Application error. 

     

    This type of error can be fixed by one one of the following:

    Please do let us know how you go. 

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Melisa_D's avatar
Melisa_D
Former Staff

Hi 6203, 

 

Thank you for your post. Can you please retrieve the diagnostic log of the AccountRight file after attempting to export to excel, if you open the error log can you see a Microsoft.Office.Interop.Excel._Application error ? If you can, 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. This type of error can be fixed by one one of the following:

Please do let us know how you go. 

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

6203's avatar
6203
Experienced Cover User
2 years ago

Thanks for your reply.

 

Please excuse my ignorance, but I don't know how to read the error report.

 

Does the report say what you were suggesting it might say?

 

This is the error report:

 

2023-01-30 15:52:22.7750,MYOB.Huxley.RF.Core.Services.AppService.RFLogService,Error,1, : System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' 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: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.get_Workbooks()
at MYOB.Huxley.RF.Extension.Export.Excel.Formatter.CreateXls(String fileName)

  • Melisa_D's avatar
    Melisa_D
    Former Staff
    2 years ago

    Hi 6203, 

     

    Looking at the error log I can see that you are experiencing the Microsoft.Office.Interop.Excel._Application error. 

     

    This type of error can be fixed by one one of the following:

    Please do let us know how you go. 

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

    • 6203's avatar
      6203
      Experienced Cover User
      2 years ago

      Thanks for your prompt assistance on this matter.  Our IT person had to do a re-install of our MS Suite.