Interfacing with MS Office

Did you know that MoneyWorks works well with Microsoft Office? You can pull reports directly into Excel, mail merge directly into Word, set your budgets straight from Excel and more. To show you how this works, we've provided some sample … Continue reading

Posted in COM/VBS | Comments Off on Interfacing with MS Office

Interfacing to MoneyWorks using COM/VBS

It is possible to attach front-end data entry systems, external data analysis, executive query facilities etc to MoneyWorks using Visual Basic (or other COM/OLE Automation-compliant scripting languages). The commands Open:    Open the specified document Usage: Open  (path as string)  ' … Continue reading

Posted in COM/VBS | Comments Off on Interfacing to MoneyWorks using COM/VBS

Deimplemented messages in external helper scripts

In MoneyWorks 7, the following messages are no longer sent to external helper scripts. OpenedDocument AllowCloseDocument ClosedDocument AllowSaveDocument SavedDocument The following messages are still sent to an external helper script. The UserLoggedIn/UserLoggingOut are not sent even if password protection is … Continue reading

Posted in AppleScript, COM/VBS | Comments Off on Deimplemented messages in external helper scripts

Registering External Helper Scripts on 64-bit Windows

The MoneyWorks GUI app runs in 32-bit mode, so external Helper scripts need to be registered as 32 bit. The following batch file will register a Helper.wsc in your custom plugins on 64-bit Windows 7. set REGTOOL="C:\Windows\SYSWOW64\REGSVR32.EXE" set TARGET="C:\Users\YOURUSERNAME\Documents\MoneyWorks Custom … Continue reading

Posted in COM/VBS | Comments Off on Registering External Helper Scripts on 64-bit Windows

Attachable Scripts

As of MoneyWorks Gold 7, attached platform-specific helper scripts are deprecated in favour of document-based MWScript scripts. You can write a script which MoneyWorks will send messages to every time something happens with the user interface (open window, validate window, … Continue reading

Posted in AppleScript, COM/VBS | Comments Off on Attachable Scripts

XML data exchange

MoneyWorks 6.1 and later supports import and export of xml-formatted data. This removes the need to preconfigure an import map when building automated importing scripts (although you will still need to understand import maps). XML is the only import format … Continue reading

Posted in COM/VBS, Database, Esoterica, MWScript, REST, XML | Comments Off on XML data exchange