Can't print reports to Excel
Hi folks. I'm running AccountRight 2023.1.24.7870 on Windows 11 pro with Office 365 Excel locally installed. I need to run my annual General Ledger and Account Recociliation reports and nothing happe...
Forum Discussion
I've got the same problem - exporting to Excel has stopped working since upgrading to 2023.1.
Hi ruthmcgormanman and David21 , welcome to the forum.
Can you find and attach your diagnostic logs to a reply?
Log locations are listed here:
https://community.myob.com/t5/Tips-and-Tricks/AccountRight-Log-Locations/td-p/582218
Attempt the Excel export, then search for the latest log file and attach that here.
Hi ruthmcgormanman , whilst it's only a change of version, I wonder if AccountRight may be unable to open the template - "error at CreateXls(String fileName)".
Can you check that the files in the template location (listed here) exist?
https://help.myob.com/wiki/display/ar/Microsoft+Excel+templates
The help page lists the templates for each report, so you can find the template for your report.
If that's OK a moderator may need to comment further.
Yes, the template was located in the folder as directed. I ended up closing MYOB, signing out of my session and signing back in. Once that was done, the report could be exported to Excel. It's working as expected now.
Thanks for your assistance.
Mike my error is.
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'.
Log attached.
Hi David21
That's a different error, for which the solution is usually to do a quick repair of Office, in Windows 10 via Add/Remove programs. Then close AccountRightg and restart.
If still not working, reinstall AccountRight and have another go.
Thanks Mike.
