VBA Macro Script on a Mac

Question

Level 1

7 points

VBA Macro Script on a Mac

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

Posted on Jul 16, 2008 5:10 PM

Reply

Answer 1

Basilisk Author

Level 1

7 points

Jul 24, 2008 6:45 PM in response to Basilisk

What, nobody come across VBA script in MS Office documents before?

Reply

Answer 2

Basilisk Author

Level 1

7 points

Oct 3, 2008 6:20 AM in response to Basilisk

Does nobody use Macros?

Reply

Answer 3

Fortuny

Level 7

21,455 points

Oct 3, 2008 6:42 AM in response to Basilisk

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

Reply