Forum Discussion

Experienced User

4 years ago

Export to Excel doesn't work

Hi I am using AccountRight Plus Au 2021.4.0 and Office 365 on Windows 10 Pro. When I try to export a MYOB report to Excel, nothing happens. I do not get an error message, simply nothing at a...

Melisa_D
4 years ago
Hi Michel-lci,

Thank you for attaching that. By looking at the error log it looks like you're experiencing a Microsoft.Office.Interop.Excel._Application error when connecting to Microsoft applications. 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:

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

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-...

Do let u know how you go.

gavin12345

Ultimate User

Hi Michel-lci

Are you both using the same version of Office - my understanding is export etc only works with 32 bit Office not 64 Bit.

Regards

Gavin

Michel-lci

Experienced User

4 years ago

HI Gavin

I am running 32 bit MS office. Exporting to Excel worked fine until a couple of months ago. Then I started getting an error. The next upgrade of MYOB fixed that. It worked for a while and now has stopped working all together.

Regards

Michel

The_Doc
Ultimate Cover User
4 years ago
Hi Michel-lci

Microsoft release and are currently releasing some real dodgey updates requiring hours of winding back auto-updates - sounds like an MS Office update possibly caused this problem. I know it happened to me with a client's MS Access application - all was well and an update created hell.

That is a hard porblem to solve - I would firstly uninstall MYOB and re-install as a 1st instance - it just may not have the integration connection correct are the update - there is a cmd line fix for this - it is the quick flash of a cmd box that opens and closes when you install MYOB - this is the MS Office integration.

Yes I believe the 32 bit version is the only version that works - however, tried to install MS Office 2019 32 bit on our servers and couldn't find the 32 bit version - am wondering whether 32 bit deprecated

MYOB can you answer - is the 32 bit version still the only version that runs the export.

The Doc
- MBLegADL
  Experienced Cover User
  4 years ago
  We should not have to be doing this, we are not in IT !!