Microsoft Says VBA Is Here To Stay 116
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 (Score:5, Funny)
Re: (Score:2, Interesting)
Re: (Score:2)
That is actually quite funny!
InnerWeb
Re: (Score:3, Insightful)
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: (Score:2)
Re:So Microsoft is at least still a *little* evil (Score:5, Informative)
Re: (Score:3, Insightful)
Re: (Score:2)
Re: (Score:1, Interesting)
Re: (Score:2)
The ones I have run into in particular are regarding charts. Stuff like changing background colours or patterns etc. Also, the macro recorder in 2K7 doesn't record a lot of things that were recorded earlier. Again, charts are a major problem. Start recording a macro, then drop the background
Re: (Score:1)
Re: (Score:3, Interesting)
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: (Score:2)
you mean I can hand someone a disk with "office" on it, tell them to install a few additional components, and they can go right into "easy" programming with VSTO?
Wow. And here I thought you needed a several-hundred dollar Visual Studio license to use VSTO. On top of the several-hundred dollar office license.
Re: (Score:1)
Re: (Score:2)
http://it.slashdot.org/article.pl?sid=08/01/17/1553206 [slashdot.org]
that was a close one. (Score:5, Insightful)
ISOfication of OOXML vs VBA (Score:5, Interesting)
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 (Score:5, Insightful)
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 (Score:4, Insightful)
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: (Score:2)
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: (Score:2)
How is this insightful? DDE has been deprecated for ages, and has no connection whatsoever with COM, and only in part a common goal with OLE. COM and OLE are also very different things, though the latter certainly uses the former (similar to how, say, JSP relies on Java). There is nothing "fundamentally flawed" about COM, most certainly not anything that has to do with se
Re: (Score:2)
I have a few macro-enabled Office documents that I signed with a CAC. It's actually pretty easy to do, and any time I save an update to the macros it automatically prompts me for my CAC. It works pretty nicely.
Re: (Score:3, Informative)
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: (Score:2)
Re: (Score:1)
Re: (Score:2)
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: (Score:2)
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
Mod AC Up (Score:2)
Of course,MS is catering to their real customers (Score:5, Interesting)
Interestingly enough:...
Looks like MS may be crippling the Mac version to stop enterprises from moving on from Windows.
Why bother? (Score:1)
Re: (Score:2)
Re: (Score:3, Informative)
Re: (Score:2)
Re:Of course,MS is catering to their real customer (Score:4, Insightful)
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: (Score:1)
And secondly, are people on slashdot REALLY complaining about VISUAL BASIC going away?!?
That's not the problem (Score:4, Insightful)
They want the damn ribbon to go away!
Re: (Score:3, Informative)
Whether we like it or not VB is
Re: (Score:2)
They want the damn ribbon to go away!
Indeed, or at least make the ribbon easy to customize, like the toolbars (and menus) used to be. My understanding is that the system can be customized using .net assemblies, but doing that is difficult even for the few users that know how to do it. It is all but impossible for the average user.
Re: (Score:2)
VBA for Mac (Score:5, Interesting)
Re: (Score:2)
Unless, maybe, openoffice support of VB/VBA is decent.
Re: (Score:1)
Cross-platform compatibility has never been terribly good anyway. I'm a non-programmer Joe Schmoe user who knocks up Excel macros because it's a convenient platform - everyone in my office has it. When I started I had a hell of a job figuring out why my macros worked in - if memory serves - Office 2000 for Win but not Mac Office 2001. Turned out there were functions that were simply missing from the Mac version, even though it was released later.
Tha
Would have been a mixed blessing (Score:4, Insightful)
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: (Score:1)
I have an Access 97 database that was built ages ago that I have to support (inherited from the business) and now I'm hitting datababase size limits and it's a zoo. There are module function calls in the queries... The horror!!!
Re: (Score:2)
Re: (Score:1)
I'll play with that a bit ans let you know.
Re: (Score:1)
Re: (Score:2)
Oh, hell, no. That thing is a joke. Corrupts its files if you breathe on it.
People need to realize that apps developed with proprietary software of any kind are BAD NEWS. I don't how perfectly it does a particular job that a particular company needs done. It's bad news in the long run. Either the company that makes it will break it, or the company itself will be bought, or go out of business. Look at SQR, the database report writing language. That thing has been sold a half dozen times, and currently
Re: (Score:2)
And the money train keeps chugging along...
Re: (Score:1)
Re: (Score:2)
Not being able to find IT work again when the
I should have learned more
Actually, no. Did you RTFA before submitting? (Score:5, Informative)
Am I missing something here?
Re:Actually, no. Did you RTFA before submitting? (Score:4, Insightful)
"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: (Score:3, Informative)
Re: (Score:2)
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."
Re: (Score:2)
(Not on the Mac)+(No new licenses)= Dead
They won't put a gun to your head, or otherwise force you to remove the documents from your computer, but rest assured that this offering will soon be cruising down 'sunset' strip.
Re: (Score:2)
There are plenty of places where the impact of VBA not running on a Mac will be zero. The fact that it's not supported on Macs doesn't make it dead at all.
Re: (Score:2)
Re: (Score:2)
It's far from uncommon for a company to stop selling licences for a particular version of software, but to keep supporting it. That certainly discourages green-field development and should encourage migration to an alternative solution over time, but it's not the same as the solution no longer being supported.
Jon
Well, that doesn't matter (Score:1, Insightful)
Re: (Score:1)
There are no comments bashing Microsoft at all so far, let alone claiming they should retain VBA.
Pandering to shills may get you mod points here, but let's keep it real, hey?
Re: (Score:2)
No, it's not.
Mac users only eh? (Score:1)
Conspiracy theories aside it could just be they are going to keep the support for Legacy systems but don't want to keep up with that junk for mac users, maybe it's harder to implement on the back end?
Re: (Score:3, Informative)
How about using .Net? (Score:4, Insightful)
Since
Most of the work is in fact already done. The Microsoft.Office.* hierarchy already exists in
Re: (Score:3, Interesting)
Re:How about using .Net? (Score:4, Informative)
Re: (Score:1)
A limerick (Score:1)
Microsoft said it was here to stay,
First they denied it, the community despised it, we can only home its deprecated.
Re: (Score:2)
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!
Still... (Score:3, Insightful)
Or Mac users could refuse en masse to "upgrade" to this "downgrade".
Oh well. (Score:1)
Re: (Score:3, Insightful)
Re: (Score:1)
Yes, that is a limitation of having people using Windows on the network...
...all the more reason to wipe Windows off it and install Fedora or Ubuntu...
Re: (Score:2)
Boggled (Score:5, Insightful)
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 (Score:3, Insightful)
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
Re: (Score:2)
Further, Office sales being healthy anyway seems like a good reason (not good TECHNICALLY, but good in business terms without being morally questionable) to me that they don't feel they need to port VBA this time.
Re: (Score:2, Insightful)
Which makes it very clear that there are good technological reasons for dropping it.
Horseshit. His post says, at great length, that they didn't want to write a whole new jitter for the mac-intel platform. Fine, sounds tough. Wouldn't interpreting the VBA opcodes be worlds easier (and more future-proof)? Or just running the good ole legacy vba engine under a mac-ppc emulator?
The real problem is that the company has lost its consumer market lock-in and is desperate to staunch Apple uptake in the enterprise, and removing VBA support is as close to a guaranteed deal breaker as they'll ever ge
Re: (Score:2)
I somehow don't believe it (Score:2)
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 (Score:3, Funny)
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 (Score:2, Interesting)
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:
Re: (Score:2)
Re: (Score:2)
Source? I see plenty of .aspx pages daily, and only occasionally stumble onto a plain .asp.
On a side note, have you watched the number of .NET vacancies posted in the last few years? It's not exactly falling, you know. Quite the opposite. For new product lines being started today, .NET/WinForms is essentially a default choice for a Win32 GUI application, and one of the major options f
If it's 'here to stay'... (Score:2)
Re: (Score:2)
VBA! Yay! (Score:1)
That would be suicidal in Excel case. (Score:2, Interesting)
VBA Went Too Far (Score:2, Insightful)
Which meant it was ripe for abuse and overuse. Too many companies have important, business critical functions/logic entombed in Excel 'macros', or Access 'applications'.
If I've understood MS's intentions, they want all office programming to be done within
Cue the Yack-son 5 (Score:2, Funny)
Easy as one, two, thray,
Do arrays the mangled way,
Rather Python any day,
Market penetration means you stay,
OK, this post is turni--