3 Replies Latest reply: Oct 3, 2008 6:20 AM by Basilisk
Basilisk Level 1 Level 1 (0 points)
How do I convert VBA script so it does the same thing on a Mac as it does in Microsoft Office?

We have a Word file that references an Excel spreadsheet, and uses some clever coding (done by someone else, I assume it's clever but it may not be) to make the document more interactive.

How can I do this please?

C2D iMac 24", PowerBook G4, PowerMac G5 DC, iMac CD, Mac OS X (10.4.11), PowerMac Server runs OS X Tiger 10.4.11
  • Basilisk Level 1 Level 1 (0 points)
    What, nobody come across VBA script in MS Office documents before?
  • Basilisk Level 1 Level 1 (0 points)
    Does nobody use Macros?
  • Fortuny Level 7 Level 7 (21,425 points)
    Hi Basilisk,

    quoted from here http://en.wikipedia.org/wiki/VisualBasic_forApplications :

    "Support for VBA in the Mac OS X version of Microsoft Office was dropped with the release of Microsoft Office 2008 for Mac. The official reason given was that VBA relied heavily on machine code written for the PowerPC architecture, and that rewriting this code for dual PowerPC/Intel architectures would have added another 2 years to the development of the suite. However, the office suite can to an extent be automated using AppleScript. In a press statement released on May 13, 2008, Microsoft's Macintosh Business Unit (Mac BU) announced that VBA will be returning in the next version of Office for Mac. Microsoft has also clearly stated that they have no plans to remove VBA from the Windows version of Office."

    Regards

    Stefan