Will VBA die?

[bansom1978]

Hi,

MS has launched Ofice 2013 with all it's collaboration featrures integrated closely with cloud based (and Sharepoint based) solution. My question is, in this scenario how VBA is well equipped? Will it be completely migrated to VSTO (.net) ? Please advice..

Thanks in advance.

Somnath

[Aflatoon]

Will VBA die? Yes, eventually, but not for a long while yet.

[Salient]

Hi,

MS has launched Ofice 2013 with all it's collaboration featrures integrated closely with cloud based (and Sharepoint based) solution. My question is, in this scenario how VBA is well equipped? Will it be completely migrated to VSTO (.net) ? Please advice..

Thanks in advance.

Somnath

Eventually vba will evolve to something else, hoever cloud or sharepoint is something I'm not noticing a big pick up on due to the inherent security issues for sensative data.

[gervie]

VBA will die, I think so, like Flash will die when HTML5 develop. Anyway, if VBA die, Microsoft will create something better than VBA.

[Dimitris254]

i'm going to use it in the next months for sure :D

[SamT]

More and more third party vendors are including the ability to use VBA to control their software. IMO, it will take as big a paradigm change as from CP/M to DOS to really kill VBA

[Bob Phillips]

VBA will die, I think so, like Flash will die when HTML5 develop. Anyway, if VBA die, Microsoft will create something better than VBA.

My, there is an optimist if ever.

[objpascal]

VBA will die, I think so, like Flash will die when HTML5 develop. Anyway, if VBA die, Microsoft will create something better than VBA.
For Flash I think the official year has been confirmed as 2020. VBA development is stil continuing.

[Bob Phillips]

For Flash I think the official year has been confirmed as 2020. VBA development is stil continuing.

Changes in the object model are (mostly/partially) added to VBA, but there is no VBA development as such. Microsoft would love to see it die, they just know that they can't kill it yet.

[Galactico]

I hope that never

[formulation]

Well, five years have passed since the op made this thread and vba is still around. With that being said, I see it sticking around for at least another 5-10 years before taking a backseat to to other languages.

[ste.bann]

Never too late to learn coding, I guess

[jfranco]

First, dropping VBA entirely from Office is not as easy as it sounds because there are so many macros powering spreadsheets (I guess even the Microsoft staff will be affected by such as measure because they surely run macros in the spreadsheets).

I understand some people are reluctant to devote their programming learning and coding efforts to a technology that might be fading away but we should remember that learning programming will pay off in many ways. For example, our time invested in learning any programming language is not wasted because all programming is based on the same principles such as instructions and decisions (aka: algorithm).

Learn the algorithm principles of programming.
Learn the Excel object model (https://www.wizdoh.com/excel-vba-object-model-demystified/) because it will be the same if you use C# or VB net because Excel won't change its native structure.

Well, coding in a dying language is something to be cautious about because the code might not be directly translatable to a new language and you might need to write everything from scratch. If Microsoft gradually moves toward a non-VBA reality, it will be toward their core languages C# and VB net. So learn C# and VB net and be ready for the future.

Thanks