Child pages
  • Error: "Error = Unable to run the specified macro"

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

This information applies to MYOB AccountRight version 19. For later versions, see our help centre.


 

 

ANSWER ID:9237

AccountRight uses the OfficeLink connection to send information to Microsoft Word and Excel. There's a few things that can affect this connection and cause an OfficeLink error. Here's an example:

Image

Which Microsoft Office versions work with AccountRight v19? See the system requirements.

OfficeLink errors can be caused by:

  • Not having Microsoft Office installed before AccountRight is installed. If your computer's hard drive is partitioned, make sure that both AccountRight and Microsoft Office are installed on the same partition.
  • Having Microsoft Word or Excel open when AccountRight tries to send the information
  • Missing or damaged OfficeLink files
  • Missing or damaged Microsoft Office files
  • A Windows corruption that prevents AccountRight from passing information to Microsoft Office

The tasks below will help fix this issue. Perform each task in order until your issue is fixed.

 

1. Register the OfficeLink drivers

OfficeLink drivers are "registered" in Windows each time your computer is started. If this registration fails, OfficeLink won't work.

To correct this:

  1. Simultaneously press the Windows Image and E keys on your keyboard (the Windows Image key is between the CTRL and ALT keys). The File Explorer or Windows Explorer window appears.
  2. Navigate to your AccountRight program folder. The table below shows the default location for your software. If you installed your software in a different location, navigate there instead.

    If using...

    Your installation folder is here
    (v19.12 or earlier)

    Your installation folder is here
    (v19.13 or later, Australia only)

    AccountRight Standard

    C:\Standard19
    N/A

    AccountRight Plus

    C:\Plus19
    C:\PlusClassic

    AccountRight Premier

    C:\Premier19
    C:\PremierClassic

    AccountRight Enterprise

    C:\Enterprise19
    C:\EnterpriseClassic
  3. In your AccountRight installation folder, locate the file called drvxl32.exe. Right-click this file and choose Run as administrator. A window appears.
  4. Close this window.
  5. In your AccountRight installation folder, locate the file called drvwd32.exe. Right-click this file and choose Run as administrator. A window appears.

    Can't find these files? Uninstall and reinstall AccountRight as described in Task 3 below.

  6. Close this window. The OfficeLink drivers are now registered.
  7. Restart your computer.

  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to Task 2.

2. Enable the OfficeLink macro

Repeat the following steps in both Microsoft Word and Excel.

If using...Do this...
Office 2010 or later
  1. Open Microsoft Word and create a new document (don't save it).
  2. Go to the File menu and choose Options.
  3. Click Trust Centre then click Trust Centre Settings.
  4. Click Macro Settings then select the Enable all macros option.
  5. Click OK then click OK again to exit the Word Options screen.
  6. Exit Microsoft Word.
  7. Repeat steps 1 to 6 in Microsoft Excel.
  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to Task 3. 

Office 2007
  1. Open Microsoft Word and create a new document (don't save it).
  2. Click the Office button in the upper left hand corner of the screen.
  3. Click Word Options > Trust Centre > Trust Centre Settings.
  4. Click Macro Settings then select the Enable all macros option.
  5. Click OK then click OK again to exit the Word Options screen.
  6. Exit Microsoft Word.
  7. Repeat steps 1 to 6 in Microsoft Excel.
  8. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed. 

If the error persists, continue to Task 3.

Office 2003
  1. Open Microsoft Word and create a new document (don't save it).
  2. Click Help > About Word > Disabled Items.
  3. The displayed window may contain a file named Addln:Myobmn97.dot. If so, highlight it and click Enable. If Addln:Myobmn97.dot isn't listed, close the About Word window.
  4. Exit Microsoft Word.
  5. Repeat steps 1 to 4 in Microsoft Excel.
  6. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to Task 3.

3. Uninstall and reinstall AccountRight

Uninstalling and reinstalling AccountRight will replace any missing or damaged OfficeLink files.

To uninstall AccountRight

  1. Close all programs on your computer.
  2. Access the list of programs installed on your computer:
    • In Windows 8 or later: Right-click in the screen's bottom-left corner and choose Programs and Features.
    • In Windows 7/Vista: Click the Windows Start button and choose Control Panel then choose Programs and Features.
  3. Click the MYOB AccountRight software to be uninstalled then click Change. In some Windows versions this may appear as Change/Uninstall.
  4. If a confirmation message is displayed, click Yes.
  5. If the Setup window is displayed, select the Remove option.
    Image
  6. Click Next.
  7. Click Yes to the confirmation message.
  8. Click Finish once the uninstall process is complete.
  9. Restart your computer.

To reinstall AccountRight (with an installation CD)

  1. Close all programs on your computer. This includes disabling any anti-virus software.
  2. Place the MYOB software CD into the disc drive. If the installation window does not automatically display:
    1. Simultaneously press the Windows and E keys on your keyboard to display My Computer (or Computer).
    2. Double-click your CD-ROM drive (usually the D: drive).
    3. Locate the file named autorun.exe and double-click it.
  3. Follow the on screen prompts to complete the installation.
  4. When complete, restart your computer.
  5. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

To reinstall AccountRight (via a download)

If needed you can download AccountRight from my.MYOB (providing you have an active support subscription). Once you've downloaded the installation file, complete the following:

  1. Close all programs on your computer. This includes temporarily disabling antivirus program.
  2. Double-click the downloaded installation file. The installation will begin.
  3. Follow the on screen prompts to complete the installation.
  4. When complete, restart your computer and re-enable your antivirus program.
  5. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the error persists, continue to Task 4.

4. Uninstall and reinstall Microsoft Office

Uninstalling and reinstalling Microsoft Office will refresh the components that are used by OfficeLink. For information on uninstalling Microsoft Office, please refer to the documentation that came with your Microsoft Office program.

Uninstalling and reinstalling Microsoft Office will affect the information stored in Outlook, including emails and contacts. Therefore this task should only be carried out by a qualified computer technician or someone who is familiar with this process and its impacts.

After uninstalling Microsoft Office:

  1. Uninstall AccountRight as described in Task 3 above.
  2. Using Windows Explorer, navigate to the Microsoft Office folder and move any documents it contains to another location, then delete the Microsoft Office folder.
  3. Visit Microsoft's website and, if available, download and run a Windows registry cleaner for your version of Windows. If you are unsure about running the Windows registry cleaner refer to your IT consultant.
  4. Reinstall Microsoft Office.
  5. Reinstall AccountRight as described in Task 3 above.
  6. Restart your computer.
  7. Test the AccountRight function you were performing when the error occurred to see if the issue is fixed.

If the issue persists, it suggests there is a problem with your Windows installation which will need to be investigated by an IT person.

 
Related topics