Automation Overview
MoneyWorks is the ideal back-office solution for your accounting needs. Find out how to integrate MoneyWorks with your own software systems.
MoneyWorks is extensible. This means that developers can add additional functionality using applications such as Visual Basic, FileMaker Pro, MS Office, Perl, AppleScript, Delphi, Access etc, with MoneyWorks acting as an integrated back-office accounting solution.
This means that you, as a developer, can focus on the special needs of your clients or application. You can 'hook' your software into MoneyWorks to submit or extract accounting information, enhancing functionality for your clients. If you've developed your own application, you'll be able to promote it to a wider audience, resulting in more sales.
Windows COM and VB
On Windows, MoneyWorks supports COM (the technology that underpins OLE Automation and VB). So from another COM compliant application (such as Access, Word, Excel, VB) you can easily extract and submit records to the MoneyWorks internal databases.
Information on the COM commands (and simple examples) are contained in the MoneyWorks Automation Guide.
Applescript
On Mac, MoneyWorks supports AppleEvents. This enables you to write scripts in AppleScript to manipulate data from MoneyWorks, or link MoneyWorks seamlessly to FileMaker Pro, Excel, RealBasic and other applications.
Information on the AppleEvents (and simple examples) are contained in the MoneyWorks Automation Guide.
FileMaker
For FileMaker Pro developers, we have prepared a plug-in that allows seamless integration between Filemaker Pro and MoneyWorks. From your customised FileMaker Pro front end you can extract information directly from MoneyWorks, and also send information (invoices, orders, time sheets etc) directly to MoneyWorks. There are two plug-ins (one for Windows and a Universal Binary one for Mac). Both these plug-ins provide the same command set, so a single FileMaker database can talk to MoneyWorks using the same commands, regardless of platform. The plug-ins work with FileMaker Pro 7 and later.
-
Plug-ins and tutorial for FileMaker 7 - 11 (300k) This requires MoneyWorks Gold 5 or later (either the demo or the full version), and FileMaker Pro 7 or later (either the demo or the full version). Plug-ins for Windows and MacOSX are included, and need to be installed into the "Extensions" folder in the "FileMaker Pro" folder. The Mac plug-in is a Universal Binary, and will not run in the Classic environment. For more details of the commands, please see the MoneyWorks Automation Guide.
-
FileMaker Pro 5.5 - 7 Tutorial (350k). This requires MoneyWorks Gold (either the demo or the full version), and FileMaker Pro 5 - 7 (either the demo or the full version). Plug-ins for Windows and MacOSX are included, and need to be installed into the "Extensions" folder in the "FileMaker Pro 7" folder.
Microsoft Office
MoneyWorks also integrates seamlessly with Microsoft Office. To see how to do a mailmerge straight into Word, send your budgets direct from Excel to MoneyWorks, automatically apply interest and more,
click here. (requires Office 2000 or later).
VB
UsingVisual Basic, you can create applications that communicate directly with MoneyWorks. Although we don't at present have any samples posted, take a look at the VBA script in the MS Office examples above to see what you need to do.
CLI
MoneyWorks Gold 5.0.8 and later has a command line interface. For documentation see the manual page, or on Mac you can use x-man-page://moneyworks (after installing MoneyWorks Gold)
Perl
A third party Perl script is available from here. It uses the Command Line Interface to talk directly to MoneyWorks Datacentre, and is a great starting point for Perl programmers who want to hook up an ecommerce site to MoneyWorks.
If you have any questions, please contact us.
