According to Macworld UK the next version of Microsoft Office for the Mac platform will feature the return of VBA support.
Although the latest version of Office for Mac’s, Office 2008, has been Microsoft’s fastest selling version of Office ever, some corporate users are unable/unwilling to upgrade from Office 2004 because of the lack of VBA support in Office 2008.
Office 2008 dropped VBA support on Mac’s in favor of AppleScript which was good and bad.
Good: Office used the same scripting language as many other Mac programs.
Bad: Documents and spreadsheets that were shared with Mac and Windows people that used macros were left unable to run on Mac’s (the document could still be opened, but the macros couldn’t run).
In separate Mac Office news, SP1 for Office 2008 should be coming today and bring with it various bug and compatibility fixes.
For more info about what’s new check out the Macworld UK post here.
Last year MacTech magazine printed in its magazine a VBA to AppleScript translation guide to help people who had written Microsoft Office macros in VBA on the Mac only to find out that Mac Office 2008 will no longer support VBA.
Office 2008 is out and MS didn’t back down on their decision to drop VBA support, so existing macros will no longer work until recreated using AppleScript.
Need a little help with the conversion? MacTech has your back and has re-released the guide as a 150-page document that includes lots of detail and step-by-step instructions.
You can read the entire document online for free here, buy a PDF version for $9.95 or a get the PDF and a hardcover version for $19.95. Both include a free subscription to MacTech magazine courtesy of the Microsoft Mac Business Unit.
For more info check out this page at MacTech.
For more info about AppleScript, check out Apple’s AppleScript page here.
Microsoft has announced that one of the 12 patches they issued Tuesday is causing Excel 2003 to make calculation mistakes.
According to Bill Sisk, security response communications manager, fixes in MS08-014 bulletin “causes Microsoft Excel 2003 calculations to return an incorrect result when a Real Time Data source is used…our teams are testing a fix and will release it once it meets our quality bar for broad distribution.”
For the time being, Microsoft is recommending that users running any function that contains a macro that refers to a Real Time Data source run the function on each cell individually rather than on an array of cells.
Microsoft has been running a beta of its new Office Live Workspace service and has decided to open it up for anyone who would like to try it out.
Office Live Workspace is a hosted version of their Sharepoint product to let users share and sync office documents. You can do basic word processing too, but you’re better off using the word processor on your computer.
For more info or to test it out yourself check out the product page here.