The new ParentDish: helping raise kids of all ages
Posts with tag vba

VBA to return in next version of Microsoft Office; SP1 released

Macworld UK is reporting that Microsoft Office 2008 for Mac saw record sales since its release, becoming the best selling version ever. Of particular interest, however, is that Microsoft has announced the next version of Office will return Visual Basic for Applications (VBA) to the Mac platform.

You may recall that one of the big brouhahas connected with Office 2008 was the elimination of VBA, which was present in Office 2004 and earlier versions; Microsoft suggested that users rearchitect their macros and automation with AppleScript. While it's generally a good thing for third-party applications to support AppleScript thoroughly, in this case it created a lot of problems for cross-platform users since the Windows version of Office depends on VBA for macros. While it is possible to duplicate some (though not all) VBA functionality with AppleScript, cross-platform macros were completely broken, leaving some users, especially in corporate environments, unwilling to upgrade from Office 2004. In this light, it is good news that VBA will return, though no timeline is yet available.

In addition to the roadmap announcements, today Microsoft is also releasing Service Pack 1 for Office for Mac 2008 with a host of improvements, including improved compatibility with Windows versions and better printing support. It should available for download at noon PDT from Microsoft or via Auto Update in Office. Full change list in the continuation of this post.

Update: Mac BU developer Erik Schwiebert has a post up on the revitalization of VBA; he originally discussed the decision not to implement it for Office 2008 here.

Continue reading VBA to return in next version of Microsoft Office; SP1 released

MacTech re-releases VBA to AppleScript Transition Guide

As someone who spent months hand-crafting Visual Basic scripts in Microsoft Office, only to have Microsoft pull the rug out from under me with the release of Office 2008 (they abandoned VB support for the Mac. Grrr.), I'm very grateful to MacTech magazine and longtime AppleScript guru Paul Berkowitz.

MacTech has re-released Paul's 150-page guide for making the transition from VBA to AppleScript (originally printed in the April 2007 issue of the magazine, and also available in modified form on the Microsoft Mac BU site). It's highly detailed, with step-by-step instructions. It looks like I know what I'll be reading next week (and if I run into trouble I can always bug Cory for help).

You can download the guide as a PDF for $9.95US, or get the PDF plus a hardcover version for $19.95US. Both options include a free subscription to MacTech magazine, which is a great bonus for anyone who likes to dig into the underside of Mac OS X. If your wallet is a bit light, you can read the entire thing online for free.

MacTech VBA to AppleScript Guide free online

We've mentioned before Microsoft's controversial decision to end support for Visual Basic (VBA) scripting in the forthcoming Office 2008 and replace it with AppleScript. While normally moving to an Apple standard technology over a closed Microsoft solution is a good thing, this move will have major repercussions with respect to cross-platform compatibility. Once this is done many scripts and macros written for the Windows versions of MS Office will no longer work on the Mac version. There is a work-around, rewriting the macros and scripts in AppleScript, though that will take some doing. Fortunately, MacTech magazine has produced a VBA to Applescript Transition Guide to help with the process. Originally the Guide was only included with the April issue of MacTech Magazine, but they have now seen the light and are offering it free on their website. You can still purchase a PDF or paper copy as well. Check it out over at MacTech.

[via The Apple Blog]

No Visual Basic in Office 2008? No thanks.

MacWindows.com recently polled readers on their willingness to upgrade to Office 2008 for Mac, which will not include Visual Basic for macros and automation (as noted on this MacBU developer blog). Several readers said they won't upgrade to 2008 because they depend on VB cross-platform support.

Where I work, we have an intricate system in place that manages and analyzes loads of data on a daily basis-a system that is dependent on homemade VB scripts. So, there's no way we're upgrading. Good job, Microsoft.

By the way, if you're left in a jam by this, check out MacTech Magazine's guide for moving from VB to Applescript, which will be available soon.

TUAW Features

Mac 101 iPhone Around the Worldask-tuaw
Mac News
Macworld (488)
.Mac (37)
Accessories (608)
Airport (69)
Analysis / Opinion (1273)
Apple (1577)
Apple Corporate (533)
Apple Financial (180)
Apple History (39)
Apple Professional (47)
Apple TV (153)
Audio (438)
Bad Apple (117)
Beta Beat (142)
Blogging (83)
Bluetooth (15)
Bugs/Recalls (56)
Cult of Mac (857)
Deals (197)
Desktops (114)
Developer (205)
Education (93)
eMac (10)
Enterprise (125)
Features (368)
Freeware (356)
Gaming (337)
Graphic Design (19)
Hardware (1251)
Holidays (37)
Humor (568)
iBook (65)
iLife (229)
iMac (182)
Internet (298)
Internet Tools (1267)
iPhone (1315)
iPod Family (1979)
iTS (941)
iTunes (779)
iWork (17)
Leopard (343)
Mac mini (109)
Mac Pro (49)
MacBook (196)
MacBook Air (70)
Macbook Pro (213)
Multimedia (421)
Odds and ends (1391)
Open Source (267)
OS (871)
Peripherals (183)
Podcasting (180)
Podcasts (83)
Portables (195)
PowerBook (135)
PowerMac G5 (49)
Retail (550)
Retro Mac (46)
Rig of the Week (42)
Rumors (596)
Software (4164)
Software Update (384)
Steve Jobs (246)
Stocking Stuffers (50)
Surveys and Polls (97)
Switchers (107)
The Woz (33)
TUAW Business (222)
Universal Binary (279)
UNIX / BSD (60)
Video (891)
Weekend Review (74)
WIN Business (47)
Wireless (78)
XServe (33)
Mac Events
One More Thing (25)
Liveblog (0)
Other Events (222)
WWDC (183)
Mac Learning
Ask TUAW (96)
Blogs (84)
Books (24)
Books and Blogs (62)
Cool tools (437)
Hacks (450)
How-tos (467)
Interviews (33)
Mods (180)
Productivity (577)
Reviews (99)
Security (142)
Terminal Tips (55)
Tips and tricks (552)
Troubleshooting (160)
TUAW Features
iPhone 101 (23)
TUAW Labs (3)
Blast From the Past (16)
TUAW Tips (137)
Flickr Find (32)
Found Footage (64)
Mac 101 (75)
TUAW Interview (31)
Widget Watch (196)
The Daily Best (1)
TUAW Faceoff (4)

RESOURCES

RSS NEWSFEEDS

Powered by Blogsmith

Sponsored Links

The Unofficial Apple Weblog (TUAW) bloggers (30 days)

#BloggerPostsCmts
1Dave Caolo500
2Cory Bohon454
3Mat Lu405
4Scott McNulty342
5Erica Sadun331
6Michael Rose2619
7Brett Terpstra230
8Steven Sande229
9Mike Schramm204
10Robert Palmer1827
11Joshua Ellis84
12Christina Warren518
13Nik Fletcher41
14Chris Ullrich32
15Jason Clarke11
16Lisa Hoover11
17Victor Agreda, Jr.14

Featured Galleries

Macworld 2008 Keynote
Macworld 2008 Build-up
Macworld Expo 2007 show floor
The Macworld Faithful in Line
iPhone First Look
iPhone 2.0 - .Mac push e-mail
iMac 1998
TUAW Faceoff: Screenshot apps on the firing line
Boston Apple Store (Boylston Street)

 

    Most Commented On (7 days)

    Recent Comments

    More Apple Analysis

    More from AOL Money and Finance

    Weblogs, Inc. Network

    Other Weblogs Inc. Network blogs you might be interested in: