VBA 6 vs Net

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TotallyConfused - 02 Nov 2007 19:45 GMT

I barely started to learn VBA and was wondering if continuing to learn VBA is
imperative to learn before learning Net. My office will be moving to
Microsoft 2007 and have been told that Net will be used. Can you please
explain the differences. Would it behoove me to continue with VBA? Thank
you.

Reply to this Message

Lance - 02 Nov 2007 20:29 GMT

It's like learning to drive a car before you start learning to drive a semi.
You're going to have to learn some new things, but the traffic laws and
"rules of the road" are going to be the same.

> I barely started to learn VBA and was wondering if continuing to learn VBA is
> imperative to learn before learning Net. My office will be moving to
> Microsoft 2007 and have been told that Net will be used. Can you please
> explain the differences. Would it behoove me to continue with VBA? Thank
> you.

Reply to this Message

John Nurick - 02 Nov 2007 21:23 GMT

Hi Totally,

It depends what for. If the aim is to produce enterprise applications
that use Word and Excel and Access and so on, VBA is old news and .NET
offers the security and scalability and stuff that's always desired
and often needed.

On the other hand if the idea is to automate Office applications at
the desktop or workgroup level, VBA will be around for at least a few
years more, and there's much less to learn before you can do useful
things. And if you're new to programming, everything you learn will be
useful if or when you move to .NET.

>I barely started to learn VBA and was wondering if continuing to learn VBA is
>imperative to learn before learning Net. My office will be moving to
>Microsoft 2007 and have been told that Net will be used. Can you please
>explain the differences. Would it behoove me to continue with VBA? Thank
>you.

--
John Nurick - Access MVP

Reply to this Message

Tony Toews [MVP] - 04 Nov 2007 17:14 GMT

>It depends what for. If the aim is to produce enterprise applications
>that use Word and Excel and Access and so on, VBA is old news and .NET
>offers the security and scalability and stuff that's always desired
>and often needed.

How does .NET provide more security?

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Reply to this Message

Albert D. Kallal - 02 Nov 2007 22:44 GMT

>I barely started to learn VBA and was wondering if continuing to learn VBA
>is
> imperative to learn before learning Net. My office will be moving to
> Microsoft 2007 and have been told that Net will be used.

The above information is incorrect. Office 2007 continues to use VBA for the
programming language.

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message