Visual Basic for Applications

[AK]

I don't want any part of the previous discussion on Visual Basic
versus Visual Basic.Net.

My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard
for studying VBA.

I use Office 2000 and would like to use VBA as a tool to customize it.
I have zero programming experience.
I would like to read through and work on the examples of a beginners
books (Dummies/Idiots/Absolute begginers or whatever) on either Visual
Basic 6 or Visual Basic.Net before I delve into VBA itself.

Has MicroSoft indicated whether or not they are changing the
background of future versions of Office VBA from VB6 to VB.Net?

[Rob Strover]

Re: Visual Basic for Applications


"AK" <cwok@aol.com > wrote in message
news:db6e6aa1.0 402151926.4058a 7a3@posting.goo gle.com...[color=blue]
> My query is about using Visual Basic for Applications; and whether it
> is better to use Visual Basic 6 or Visual Basic.Net as a springboard
> for studying VBA.[/color]

VB6 is definitely the better springboard, but see the comment in the next
paragraph. The.NET 'thing' is called VB, but is really quite a different
language in many respects to 'classic' VB and certainly NOT relevant to VBA.

Why do you need to use VB as a springboard? - VBA works within a development
environment very similar to the VB one, except you can't create ActiveX
components or 'independent' executables.
[color=blue]
> Has MicroSoft indicated whether or not they are changing the
> background of future versions of Office VBA from VB6 to VB.Net?[/color]

Not sure about this one, but I don't believe that Office 2003 has .full (if
any) NET functionality (not that I've heard of, anyway).

BTW, for questions relating to Office Object Model issues, you're probably
better off using msnews.microsof t.com newsgroups relevant to the MS products
you are using as the VBA host (eg, Word, Excel, etc.).

Good luck, and ask here if you have any further questions.

HTH

Rob.

[Suzette]

Re: Visual Basic for Applications

If you don't have experience programming, don't bother with VB at all. It
will confuse you. Although many things are similar in VB there are a lot of
differences between VB and VBA. I program in both. In a LOT of cases
(especially in Excel) you can use the macro learn function as a springboard
to work with.

Here's a book that might help

http://www.target.com/gp/detail.html/ref=br_1_10/601-7033574-3617715?%5Fencoding=UTF8&asin=B0000BYQ4Z

Ken Getz is an instructor with AppDev and a MVP.

another option if you are going to do a LOT in VBA is the AppDev course

http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=VBAProduct

I got it after programming for some time and learned some nifty stuff.

Of course the least expensive way is to start, use the help screens and post
to the newsgroups for help. I've always have great luck.

Sue

"AK" <cwok@aol.com > wrote in message
news:db6e6aa1.0 402151926.4058a 7a3@posting.goo gle.com...[color=blue]
> I don't want any part of the previous discussion on Visual Basic
> versus Visual Basic.Net.
>
> My query is about using Visual Basic for Applications; and whether it
> is better to use Visual Basic 6 or Visual Basic.Net as a springboard
> for studying VBA.
>
> I use Office 2000 and would like to use VBA as a tool to customize it.
> I have zero programming experience.
> I would like to read through and work on the examples of a beginners
> books (Dummies/Idiots/Absolute begginers or whatever) on either Visual
> Basic 6 or Visual Basic.Net before I delve into VBA itself.
>
> Has MicroSoft indicated whether or not they are changing the
> background of future versions of Office VBA from VB6 to VB.Net?[/color]