Case Studies - Assetlink

AppleScript Development

Assetlink
Software Developers

1 manager / developer, 5 days

Software Technologies

AppleScript

Microsoft Office 2007 Support In Multi-Platform Environments - Assetlink

Assetlink is a specialist provider of marketing software solutions for Global 2000 companies. When support for macros was removed from the Mac version of Office 2007 by Microsoft, Assetlink approached Blueberry Consultants to solve the problem of using Excel spreadsheets in a multi-platform office environment.

In one of Assetlink’s systems, customers use Microsoft Excel to record information for later entry into a database. An embedded macro within Excel normally converts the input data to an XML file, which is then accepted by the cataloguing engine.

When support for macros was removed from the Mac version of Office 2007, an alternative method of generating the XML files was required, which would retain the familiar spreadsheet user interface.

Blueberry analysed the existing Excel macros and developed the AppleScript for OSX 10.4 (Tiger) and OSX 10.5 (Leopard), as well as for PPC and Intel based machines – so continuing support for Mac Office 2007 users.