Officelink (Excel, Word, etc) Troubleshooting
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.
The following are some alerts that can be generated from Microsoft Office programs:
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
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:
|32-bit machines (Office 2007-2010)||
|64-bit machines (Office 2007-2010)||
|Office 2013 (32-bit version)||
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
- 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 AccountEdge
- Uninstall Microsoft Office
- Reinstall Microsoft Office
- Reinstall AccountEdge
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.