Just another WordPress.com weblog

Posts tagged “office

VBA returning to next version of Mac Office, SP1 coming today


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.

[Via TUAW]


VBA to AppleScript translation guide re-released by MacTech

applescriptLast 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.

[Via TUAW]

Hate the Office 2007 menus? Change them with Addintools Classic Menu


Some people like the new look and feel of Office 2007, some don’t. Those that don’t really, really hate it.

Microsoft doesn’t give you a way change the look and feel back to, say, Office 2003, but an add-on I just found by Addintools looks like it will do the trick.

Classic Menu for Office 2007 is an add-on that will let you replace the ribbon bar with the style of menus you’re used to so you don’t have to spend so much time trying to find what you’re looking for.

I don’t have Office 2007 myself or I’d try it out myself, but if you do and more or less hate it, try checking out Classing Menu and see if it makes your life a bit easier.

A free trial version is available and if you like it you can buy it for $29.95. For that price, it will let you change the menus for Word, Excel, Access, Outlook and PowerPoint.

Don’t need all of those? You can buy Classic Menu for just one of the programs in Office 2007 for just $15.99.

For more info check out the product page here.

MS patch for Excel causes calulation errors


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.

[Via Computerworld]

Microsoft opens Office Live Workspace beta to public

office_live_workspaceMicrosoft 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.

[Via TechCrunch]