Microsoft Says VBA Is Here To Stay

Angostura writes "Microsoft's team blog for Microsoft Excel and Excel Services has responded with a denial to the earlier report that Visual Basic for Applications will disappear from Windows Office in 2009. The Slashdot discussion on the report on Tuesday got pretty animated."

So Microsoft is at least still a *little* evil

[sapone (152094)]

If they had they rid the world of VBA on top of publishing their binary specs in an Open Source compatible way, their reputation bar might have ended up on the "good guy" side :).

Re:

[by Anonymous Coward]

And if it's true that VBA is sticking around, then the folks running the Mac BU are liars. Either way, Microsoft can't be trusted.

Re:

[innerweb (721995)]

That is actually quite funny!

InnerWeb

Re:

[smitty_one_each (243267)]

Not necessarily. If the main VBA users are the PC-based ones, then MS could drop Mac support, retain PC, and the story is "reasonably" clear.
In any case, with the number of people involved in frobnicating the decision, there really isn't a need to label anyone a liar. Policies are variables, not constants, and get new values assigned to them frequently during business execution.

Re:So Microsoft is at least still a *little* evil

[kestasjk (933987)]

There's no way they were going to release an Office suite without any macro capability, but the blow is that they aren't replacing it with .NET .

Re:

[by Anonymous Coward]

I work with big banks on the fixed income side, and most traders have some excel spreadsheets with custom macros developed by internal IT. MS has to keep new version backward compatible. There is no way MS will break these spreadsheets, or else they'll piss off plenty of rich people and big companies.

Re:

[rtb61 (674572)]

Now that is an utter and total lie. M$ will with out any qualms or favour break every macro in every spreadsheet in they believe it will make them money and they have already done it once. I likeed the simple little macro language that cam with every spreadsheet program, sure there were some differences but it basically followed the same logic as the spreadsheet program itself.

Then the asshats at M$ wanted to make more money selling software licences for Bills baby, VBA, so fuck all the customers using sp

Re:

[Your.Master (1088569)]

He's not. He's referring to this:

http://it.slashdot.org/article.pl?sid=08/01/17/1553206 [slashdot.org]

that was a close one.

[kellyb9 (954229)]

Oh thank god... don't know what I'd do without that!

ISOfication of OOXML vs VBA

[jkrise (535370)]

If OOXML is to become an ISO standard fully implemented in Office 2009; VBA and binary blobs will have to be deprecated and removed from the feature list.

Else, after ISO approval is sought and obtained, MS might claim it is deprecated but still provide support in Office..... either way, confused times ahead for the Office cash cow, methinks.

Re:ISOfication of OOXML vs VBA

[morgan_greywolf (835522)]

Agreed. VBA obviously can't be part of the ISO-ificated OOXML. VBA is probably going to be considered a 'legacy' feature, with recommendations that customers do new development on VSTA/VSTO.

If history is any judge, many VBA apps will one day not work in future versions of Office anyhow. MSFT does plenty to break compatibility between releases. In fact, some VBA apps developed for Office 97 won't work on Office 2000 or later.

Re:ISOfication of OOXML vs VBA

[ozmanjusri (601766)]

If history is any judge, many VBA apps will one day not work in future versions of Office anyhow.

Actually, that should happen sooner rather than later, so this announcement is a retrograde step.

DDE, OLE, COM and DCOM are fundamentally flawed models which were developed in a much less fraught security environment than we have now. VBA is heavily tied into that same flawed architecture.

Microsoft has tried to address the exposures by disabling macros by default in Office, but the control they provide isn't fine-grained enough to do more than pass the buck to the customers who have to enable the lower security levels to get their documents working.

They do have an answer in .NET, but until Office is re-written for that platform, and until there's some sort of converter for the massive collection of existing VBA to VBA.NET, they're stuck with the risky and clunky security fix.

Re:

[samkass (174571)]

DDE, OLE, COM and DCOM are fundamentally flawed models which were developed in a much less fraught security environment than we have now.

And in a much more resource-constrained environment. There were definitely models that worked much better, such as CORBA, SOM, etc., but doing things right consumes a lot more resources, so tends to be less performant. It's only when we got gobs of extra computing power, bandwidth, etc., that we're able to make interfaces that are both secure and performant. I suspect i

Re:

[MightyYar (622222)]

I've got no problem with them revamping VBA and breaking things here and there to make everything more robust. I'd much rather fix existing macros than start from scratch.

We're smarter now and we typically make web apps, but when Excel 5.0 (IIRC) came out with VBA, it was like geek crack. We made so many VBA macros that it seems like that was all I did for a few years. Now, practically our whole measurement lab relies on VBA in some way or another. It would be quite a bit of work to re-write all of those li

Re:

[Dan667 (564390)]

All of my perl scripts still work. I build a bunch of vba crap and then they broke with new office versions so I built the same functionality with perl (Excel::spreadsheets) and you know what, they still work. Yea for perl!

Re:

[jimktrains (838227)]

VBA is very nice and helps implement little features that come in handy, especially in Excel.

I don't think there is any reason VBA cannot be part of the standard, as long as it itself is standardized. There is no reason that this tool should be removed because of dumb users. The default setting in office is to not allow macros and if you want to use them you have to turn them on, I'm perfectly fine with that.

Re:

[MrNemesis (587188)]

Can someone more familiar with theses document formats please clarify:

Surely the only sensible place to implement a macro runtime is in the application itself, and just use a meta-object to store the code in the doc itself...? Wouldn't it make more sense for the doc to just have a standardidsed API that any macro-enabled application that supported the format could interact with?

Apologies if this is already what it does, but saying "removing support for VBA from OOXML" seems to suggest that OOXML needs to ha

Of course,MS is catering to their real customers

[Coopjust (872796)]

And despite the security problems that have plagued users for years due to VBA viruses, Microsoft won't remove VBA from Office.

Interestingly enough:...

While it's true that VBA isn't supported in the latest version of Office for the Mac and the VBA licensing program did close to new customers last year, we have no plans to remove VBA from future versions of Office for Windows

Looks like MS may be crippling the Mac version to stop enterprises from moving on from Windows.

Re:Of course,MS is catering to their real customer

[samkass (174571)]

Looks like MS may be crippling the Mac version to stop enterprises from moving on from Windows.

Vista needs some competitive advantage over MacOS X, I guess. Since OpenOffice supports it, though, I suspect most Mac users would rather give up MS Office than MacOS when possible. Considering the Mac is growing 2-3x the industry rate, tying Office to Windows in this manner is just Microsoft nailing one more nail in their own coffin.

Re:

[EXMSFT (935404)]

Or more likely, VMware Fusion or Parallels...

Re:

[sconeu (64226)]

That's fine with MS. You have to buy a Windows license to do that.

Re:

[Bill, Shooter of Bul (629286)]

It raises the cost and complexity of using the mac platform. Crossover isn't free, nor is parallels.

That's not the problem

[Apocalypse111 (597674)]

Customers don't want VBA to go away.

They want the damn ribbon to go away!

Re:

[ChefInnocent (667809)]

I don't know why you were modded 'Troll'. I think your statements are accurate. There are way too many lines of VB code written for businesses to want it to go away. If they had to re-write those lines (no matter what new language will be, or what the quality of the VB is), they would more likely abandon the need to upgrade. As for the ribbon, I haven't seen it, but that might be because my company didn't think it was necessary to upgrade to the current version of Office.

Whether we like it or not VB is

VBA for Mac

[christurkel (520220)]

VBA for Office Mac was dropped because AppleScript is far more powerful for the task and by dropping VBA you hinder cross platform compatibility. Devious.

Re:

[marcello_dl (667940)]

Devious but now VBA is not cross platform anymore, which makes it even less appealing for people who cater to a mixed audience. Not that I see many cases where passing around documents with embedded scripts is the way to go, but YMMV.

Unless, maybe, openoffice support of VB/VBA is decent.

Would have been a mixed blessing

[HangingChad (677530)]

I absolutely hate VBA but it's conflicted because I've made so much money untangling some spaghetti coded VBA nightmare cobbled together as a spare time project that became a legacy application no one can live without.

Hate the language, love the money from fixing it.

Re:

[S.O.B. (136083)]

Now you can make money converting VBA macros to AppleScript for all those Mac users out there.

And the money train keeps chugging along...

Actually, no. Did you RTFA before submitting?

[BobMcD (601576)]

The link that _I_ clicked took me to a blog that said that VBA was no longer supported, and that the licensing program had gone away. To me this means 'dead'. No support and no license means that no reputable vendor is going to nail any new shingles to this product. Any future offerings using VBA are destined to be either snakeoil or shareware.

Am I missing something here?

Re:Actually, no. Did you RTFA before submitting?

[HiredMan (5546)]

VBA is gone from Office for the Mac and VBA developers is closed. Microsoft is acknowledging that both these "clues" that made people conclude that VBA in Office was going away are true - but they contend that VBA in Office is not going away.

"The facts you cited are right - but your logical conclusion was wrong. We're Microsoft and we are not bound by logic."

Basically.

=tkk

Re:

[Richard_at_work (517087)]

The entire article is thus -

Following MacWorld earlier this week, there has been some inaccurate information circulating online regarding VBA support in Office for Windows. While it's true that VBA isn't supported in the latest version of Office for the Mac and the VBA licensing program did close to new customers last year, we have no plans to remove VBA from future versions of Office for Windows. We understand that VBA is a critical capability for large numbers of our customers; accordingly, there is no pl

Re:

[Westley (99238)]

Where exactly did you read that it was no longer supported? The articles states that it's no longer supported *on the Mac*. That's not the same thing as "no longer supported".

The way I read it, the message is "If you're on Windows and depend on VBA, don't worry - you can still upgrade to the latest version of Office (for Windows). That said, we're strongly discouraging future VBA development."

How about using .Net?

[mallardtheduck (760315)]

What I would like to see would be a .net based macro system in Office. Something where we could write macros in VB, C#, Python, or any other CLR language.

Since .Net has built-in support for different trust levels, code signing, etc., security should be more manageable.

Most of the work is in fact already done. The Microsoft.Office.* hierarchy already exists in .Net, all that is really needed is a way to embed .Net code in MS Office documents.

Re:

[Shados (741919)]

It won't be long... I mean, SSIS's script components already use VB.NET (and in the next version can use more languages), so the scaffold is already there.

Re:How about using .Net?

[andy9701 (112808)]

Isn't that what Visual Studio Tools for Office [microsoft.com] does? I've never really looked into it much, but my understanding was that it was a .NET replacement for writing Office apps with VBA.

Still...

[Nom du Keyboard (633989)]

Still, even if they keep in in Windows Office, there's no question that it's gone in Mac Office 2008, and that's a huge monkey wrench in mixed business environments. While I'm sure that the Microsoft "solution" is to just have you dual-boot into Vista when you need to run VBA on your Mac, this seems to clearly be an attack on Apple's recent success, and could be a deal-breaker in a significant number of environments.

Or Mac users could refuse en masse to "upgrade" to this "downgrade".

Boggled

[samael (12612)]

Has anyone actually read the original explanation for why Office 2008 isn't getting VBA?

http://www.schwieb.com/blog/2006/08/08/saying-goodbye-to-visual-basic/ [schwieb.com]

Which makes it very clear that there are good technological reasons for dropping it. Or, at least, it's going to be such a huge amount of work to bring it natively to Intel that it's not worth it to MS.

I mean, sure, some people at MS may be happy about it vanishing, but it doesn't sound like a conspiracy to me...

Embrace, Extend, Extinguish

[Foerstner (931398)]

Or, at least, it's going to be such a huge amount of work to bring it natively to Intel that it's not worth it to MS.

At one time in the past, Microsoft considered it worthwhile to port VBA from Intel and Win32 to PowerPC and the Classic Mac Toolbox.

Today, it's too much effort to either 1) update the existing VBA engine or 2. Replicate the previous clean-sheet effort. Despite the fact that the Mac is growing in market share, and Office sales are very healthy [microsoft-watch.com] --something that could hardly be said back in the l

I somehow don't believe it

[pizzach (1011925)]

It might take a few years, but I believe VBA is on it's way out. It's just Mac developers tend to jump the gun a few years early. (Dropping serial ports for only USB, dropping the floppy drives, dropping the cdrom bay...)

If VBA is actually here to stay, I say the telltale sign will be if VBA support is included in the NEXT version of Mac Office X. That is called backtracking.

My thoughts in lyrical form

[Philotechnia (1131943)]

Sung to the tune of "Chocolate Rain" by Tay Zonday
http://www.youtube.com/watch?v=EwTZ2xpQwpA [youtube.com]
(If you don't know, now you know)


VBA
So many people writing code in vain
VBA
Debugging apps is really quite a pain

VBA
Microsoft says it will not support
VBA
To C#, functionality we'll port

VBA
No rhyme or reason to deploy this mess
VBA
A seasoned coder really could care less

VBA
Slashdot will flame Microsoft either way
VBA
Now I'm confused why it is here to stay

May Deny But Intentions Are Clear

[littlewink (996298)]

VBScript is the core language of VBA and was the only extant language omitted with the release of .NET. Microsoft's language development groups didn't want to support the language - classic VB and VBA were held to be hacks. So it was proposed that VB/VBA be killed.

In a most unusual display of synchronicity, Microsoft's marketing group also wanted VBScript killed because:

• it was a "free language" - VBScript & ASP enabled web development in Notepad - selling Visual Studio development tools was next to

Re:

[cyber-vandal (148830)]

Is it not possible to replace VBScript with JScript?

If it's 'here to stay'...

[theurge14 (820596)]

...then why was it just cut out of Microsoft Office 2008 for Mac? If we Mac users are supposed to use Applescript instead of VBA, then where are the Microsoft supplied tools to convert VBA to Applescript? Does Microsoft not care about their customers enough to ensure compatibility between their most recent Office release?

Re:

[sherriw (794536)]

If you aren't running your MS sofware on an MS operating system, then you aren't a real customer. Heh.

Cue the Yack-son 5

[smitty_one_each (243267)]

V - B - A
Easy as one, two, thray,
Do arrays the mangled way,
Rather Python any day,
Market penetration means you stay,
OK, this post is turni--

Mod AC Up

[mpapet (761907)]

Informative, Insightful, Funny. Just pick one.

Re:

[cnettel (836611)]

VBA relies on COM and parts of the original (up to VB6) VB engine to do its job. The Mac layer was based on a COM implementation on Mac. To continue the licensing scheme, they would have to maintain the complete library and eventually port it to 64-bitness. Just keeping the bits needed for Office can be simpler. At least, they won't have to maintain an external-product quality interface to the host application developers anymore. VBA support in a future Office release might be done through process separatio

Re:

[Dephex Twin (416238)]

There once was a poet named Banner
Who composed in a god-awful manner
With hardly a rhyme
Or awareness of time
He'd do well with some Lear and a scanner!

Re:

[thePowerOfGrayskull (905905)]

...which is great until they want to share a document w/ macros with someone on Windows...

Re:

[Hatta (162192)]

We bashed them when we read that they wante to drop it. let's bash them because they don't. Hell, this is Slashdor, isn't it?

No, it's not.