Free Newsletters
Technology & Business Daily

InfoWorld
Log-in | Register

What Visual Basic's Office return means for Mac IT

The return of Visual Basic helps to solve some of the problems Office for Mac users face, but many others will remain


Microsoft's Mac Business Unit overshadowed the release of an Office 2008 update by announcing a feature that won't even be available until the next major overhaul of its productivity suite--the return of VBA functionality. (Note: return. Entourage, never having had VBA functionality is highly unlikely to have that functionality returned.)

Tuesday's news is a very good thing for business and cross-platform users. The (formerly permanent) loss of support for Visual Basic for Applications has been a serious problem for Office's Mac users, especially those who rely on the Excel spreadsheet application. Even with the improvements in Office 2008's AppleScript implementations, VBA could do in Office what AppleScript can't -- recording Macros, cross-platform usage, embedding macros, and customizing the Office UI, to name a few.

So the Mac IT crowd should be rejoicing, right? Sure, except for three items that mar the announcement. First, going by Office release cycles, it's going to take at least two-and-a-half years for VBA support to return, assuming no delays caused by dependencies on codebase changes with the Windows version of Office. Second, it's going to cost you another $300 to $400 to get the restored functionality.

The third problem is perhaps the most significant: Many companies are starting to ask "Do we really need to care?" Right now, most companies of 100 employees or more that side-grade to Office 2008 (I can't really bring myself to consider it an upgrade) still have to run every part of Office 2004 other than Entourage or Messenger. Why? The missing VBA support.

At this point, in the business world, the only compelling reasons for Office 2008 are improvements in Entourage 2008 (particularly in the database code) and support for the XML file formats. Outside of Entourage, I've found the performance improvements for Office 2008 to be a wash over Office 2004, even on an Intel-based Mac. I can almost launch Word 2007 inside a VMware Fusion virtual machine faster than I can launch Word 2008 natively. In either case, if I want to stay with Microsoft Office on a Mac, and use Office 2008 in a business situation, I have to keep two versions of Office on my Mac. I don't have a choice. That's not good, because then I start asking "Why do I need Microsoft Office on my Mac?" And even VBA's return is not going to be the only item that answers that question.

Right now, out of the choices that don't require a virtual machine or some form of WINE, Office 2008's only major advantage is handling documents that have embedded objects. The current release versions of OpenOffice and NeoOffice don't deal with those reliably, and iWork '08 doesn't deal with them at all. However, once you get outside of that requirement, the "need" for Office 2008 shrinks rapidly for the home-small business users. I haven't needed to use Microsoft Office since iWork '08 came out. I like Entourage, so I use that, but for my needs, iWork '08 plus Entourage 2008 has been a stellar combination.

When you shift to medium- to large-business users, the case for any version of Microsoft Office on the Mac gets worse, because then you start running into things like SharePoint and IRM, or Information Rights Management.

SharePoint is Microsoft's document management architecture that ties into Office on Windows. Think of it as CVS or Adobe Version Cue for Microsoft Office. SharePoint includes a lot more, such as Public Folder functionality for Exchange 2007, web portals, collaboration, and so forth, but document management is a major part of it.

Continued
1 | 2 | NEXT PAGE » 


Talkback:

commentPost a Comment

 

MOST COMMENTS

 
 





Beyond AntiVirus: Symantec Endpoint Protection
Today's threats to the endpoint are much more dangerous as they rapidly evolve to evade traditional security measures. To combat these threats, companies should supplement existing security with proactive behavioral based technologies. Join this webcast to learn about Symantec's next generation AntiVirus solution that provides that level of protection. Sponsor: Symantec

»  Click here to view this Webcast
  Virtualization Solutions Guide
This comprehensive IT Strategy Guide covers Virtualization and puts you at the forefront of the discussion. You'll learn all you need to know from the cost of virtualization, how to implement it for your business, how to back it up safely and which products are best. Sponsored by Riverbed

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 
 

Video

 
 
 

Podcasts

 
 
 

 

Columnists

 
 
 

Resource Center


Ads by techwords beta  [See your link here]
 




Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS  CAREERS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist