Any former VBA programmers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just saw Vista and Office 12 yesterday at a MS event, and it looks like it
us VBA programmers will be forced to move to .NET.

Are there any other former VBA programmers out there? Do you have any
suggestions on how to make this process less painful? I really need some
reassurance that my brain isn't going to have a meltdown! Thanks.
 
Ok, just breathe, it's going to be all right.

First off, I'm not sure why you didn't see this coming 5 years ago when MS
introduced .NET as its new Windows development platform, but in any event
going from VBA to VB .NET won't be a Herculean effort (but, yes there will
be effort involved).

The first place to start would be a good book/online reference on the .NET
Framework and the VB.NET language. "Programming Visual Basic .NET" by
Francesco Balena (published by MS Press) is a very good resource.

On the surface, the VB .NET syntax is somewhat similar to VB 6.0, but
underneath there is a completely different "engine" driving this train.
Understanding it will help you to understand much of the new syntax of VB
..NET.

Good luck.
 
If you are at you ease with programming concepts it shouldn't be a problem.
All languages are always based on the same logic or do you have a particular
point in mind...
 
Thanks, Scott.

Scott M. said:
Ok, just breathe, it's going to be all right.

First off, I'm not sure why you didn't see this coming 5 years ago when MS
introduced .NET as its new Windows development platform, but in any event
going from VBA to VB .NET won't be a Herculean effort (but, yes there will
be effort involved).

The first place to start would be a good book/online reference on the .NET
Framework and the VB.NET language. "Programming Visual Basic .NET" by
Francesco Balena (published by MS Press) is a very good resource.

On the surface, the VB .NET syntax is somewhat similar to VB 6.0, but
underneath there is a completely different "engine" driving this train.
Understanding it will help you to understand much of the new syntax of VB
..NET.

Good luck.
Click to expand...
 
I guess my point was, I have a LOT of code to re-do - I'm not looking forward
to it. I'm supporting Office 97 through 2003 right now, and I'm sure .NET
will not work very well with 97 and 2000. These particular clients are not
likely to upgrade any year soon, either. It's difficult enough to maintain
code changes in VBA, much less an entirely diferent platform. Arg.

As far as programming concepts, there's no problem there - I was a computer
science major. However, my C++ instructor was terrible and I dropped the
class. Do you think C# was be worthwhile to put under my belt? It seems a
lot of .NET programmers are using it.
 
Thank you, Patrice. You have been most helpful.

Patrice said:
If you are at you ease with programming concepts it shouldn't be a problem.
All languages are always based on the same logic or do you have a particular
point in mind...
Click to expand...
 
Back
Top