Officelink (Excel, Word, etc) Troubleshooting

Background
Error Message
Troubleshooting OLE Errors

Background

OfficeLink is a function that allows you to automatically create word processing and spreadsheet documents using AccountEdge data. You must be using OfficeLink-compatible word processing and spreadsheet program, for example Microsoft Word and Excel.

Anything that affects the computer system environment can cause OfficeLink to stop functioning.

Error Messages

The following are some alerts that can be generated from Microsoft Office programs:

  • drvwd32
    OLE Dispatch error:/n Macro=MyobGetTag/n Error = Unable to run the specified macro
  • Error in OfficeLink
  • Failure to create OLE driver object
  • Macro = MYOBGet Tag/n error
  • Unable to locate the necessary files to perform this OfficeLink function

Troubleshooting OLE Errors

Reinstall AccountEdge

The OfficeLink components did not install successfully. Consequently, the Myobmn97.dot file that contains MYOB's macros did not get put in the correct folder. Folder locations are:



Machine Folder
32-bit machines (Office 2007-2010) C:\Program Files\Microsoft Office\Office\Startup
64-bit machines (Office 2007-2010) C:\Program Files (x86)\Microsoft Office\Officexx\STARTUP
Office 2013 (32-bit version) C:\Program Files\Microsoft Office 15\root\Office15\STARTUP

If you look in this path, you should find Myobmn97.dot file. You can re-install AccountEdge and make sure the Myobmn97.dot file is installed where it belongs.

Register the OfficeLink drivers

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

To correct this:
Press and hold the Windows key on your keyboard (between the CTRL and ALT keys) and press the R key. The Run window is displayed.
Type the applicable 2 commands for the AccountEdge version being used, clicking OK after entering the command:

  • AccountEdge 2011:
    • C:\AccountEdge2011\DrvWD32.exe /register
    • C:\AccountEdge2011\DrvXL32.exe /register
  • AccountEdge Pro 2012 and Later:
    • C:\AccountEdgePro20YY\DrvWD32.exe /register
    • C:\AccountEdgePro20YY\DrvXL32.exe /register

Notes:

  • The above assumes your accounting software has been installed in its default folder.
  • YY indicates the version of your software

Enable the OfficeLink Macro

Refer to the Office documentation about enabling macros.

Uninstall and reinstall Microsoft Office

You would want to take the following steps to uninstall Microsoft Office:

Uninstall and reinstall Microsoft Windows

This should be a last resort. You should not reinstall Microsoft Windows unless all other solutions have failed. Please see your IT professional before attempting this.