What are the differences between vb, vb.net, & vba ?
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
-
-
Re: vb, vb.net, & vba
To my understanding, VB is Visual Basic, which is the basis for VB.net,
a newer build (created in 2003). IT includes lots of new stuff, and
puts VB on a par with other languages in terms of OOP and other stuff.
Macros are coded in VBA (Visual Basic for Applications). It includes
special features and references that mean that you can use VB with
Excel etc
I'm sure someone else will redefine it, but this is roughly right isn't
it?
Hope this helps,
Jarry
DesCF wrote:--What are the differences between vb, vb.net, & vba ?
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Warhammer fan? Visit http://www.freewebs.com/warhammer40k4U
-
Re: vb, vb.net, & vba
Macros are coded in VBA (Visual Basic for Applications). It includesActually, vba is (imo) a very scaled down version of classic visualspecial features and references that mean that you can use VB with
Excel etc
basic. It's main purpose is help automate Microsoft Office products (or
some other applications). For example MS Access uses VBA to power the
forms, reports, etc in a database application. You can even build
simple UI forms to help user automate complex tasks. Excel uses it to
define custom functions or like Jarry said to write macros. It can be
used in Outlook to take special actions on emails. The list
continues....
It should be noted that anything that can be done in VBA can be done
with classic visual basic, so vba doesn't really have any special
features, it just includes the neccessary references to the program (be
it word, excel, or access). Also, anything done in classic vb can be
done (some easier some harder) with VB.Net. This "chain" doesn't work
the other direction (i.e. vba cannot do most things VB.Net can). The
point here is that (imo) vba is at the bottom of the visual basic food
chain, then comes classic vb *sigh*, and then the reigning king right
now is VB.Net (again in my opinion).
Hope that helps,
Seth Rowe
Jarry wrote:To my understanding, VB is Visual Basic, which is the basis for VB.net,
a newer build (created in 2003). IT includes lots of new stuff, and
puts VB on a par with other languages in terms of OOP and other stuff.
Macros are coded in VBA (Visual Basic for Applications). It includes
special features and references that mean that you can use VB with
Excel etc
>
I'm sure someone else will redefine it, but this is roughly right isn't
it?
Hope this helps,
Jarry
>
DesCF wrote:>What are the differences between vb, vb.net, & vba ?
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Warhammer fan? Visit http://www.freewebs.com/warhammer40k4UComment
-
Re: vb, vb.net, & vba
"DesCF" <descf@aol.comw rote in message news:op.th0tsow xupgxg0@descsta r...What are the differences between vb, vb.net, & vba ?
They have been obfuscated to an extent by Microsoft, but broadly it is this.
VB is the name given to the older versions of Visual Basic, up to and
including VB6 which was released in about 1998.
VB.NET is the name generally given to more recent versions of Visual Basic
released from 2000 onwards, and which make use of the .net framework.
Although VB.NET is claimed by Microsoft to be an update to VB, they aren't
all that compatible and you should be wary about attempting to port any
project of significant size from VB6 to any later version.
The obfuscation creeps in because Microsoft calls the most recent version
"VB2005", dropping the .net suffix from the name even though it uses the
VB.NET syntax, not the VB6 syntax.
VBA (Visual Basic for Applications) is the version of VB that is included
inside various of the Microsoft Office applications, and is also licensed by
Microsoft for other companies to include within their own applications. It
uses the VB6 syntax and usually makes available a specialised object model
for controlling the host application, and has a simpler forms library than
VB6 (VBA UserForms are simpler and less capable than VB6 Forms).
General-purpose VB6 code can often be imported into VBA projects and work
unmodified.
--
Regards
Jonathan West - Word MVP
Please reply to the newsgroup
Comment
-
Re: vb, vb.net, & vba
Thanks for all that, clears it up nicely. Are there any books out there
on vb.net that anyone would recommend ?
On Thu, 26 Oct 2006 12:56:50 +0100, Jonathan West <jwest@mvps.org wrote:
>
"DesCF" <descf@aol.comw rote in message
news:op.th0tsow xupgxg0@descsta r...>>What are the differences between vb, vb.net, & vba ?
>
They have been obfuscated to an extent by Microsoft, but broadly it is
this.
>
VB is the name given to the older versions of Visual Basic, up to and
including VB6 which was released in about 1998.
>
VB.NET is the name generally given to more recent versions of Visual
Basic
released from 2000 onwards, and which make use of the .net framework.
Although VB.NET is claimed by Microsoft to be an update to VB, they
aren't
all that compatible and you should be wary about attempting to port any
project of significant size from VB6 to any later version.
>
The obfuscation creeps in because Microsoft calls the most recent version
"VB2005", dropping the .net suffix from the name even though it uses the
VB.NET syntax, not the VB6 syntax.
>
VBA (Visual Basic for Applications) is the version of VB that is included
inside various of the Microsoft Office applications, and is also
licensed by
Microsoft for other companies to include within their own applications.
It
uses the VB6 syntax and usually makes available a specialised object
model
for controlling the host application, and has a simpler forms library
than
VB6 (VBA UserForms are simpler and less capable than VB6 Forms).
General-purpose VB6 code can often be imported into VBA projects and work
unmodified.
>
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Comment
-
Re: vb, vb.net, & vba
For the language, I highly recommend "Programmin g Microsoft Visual Basic
2005: the Language" by Francesco Balena. It doesn't cover data access, web
stuff, forms, etc. -- just the language itself. I've found it to be very
readable.
For forms, check out "Pro .Net 2.0 Windows Forms and Custom Controls in VB
2005." by Matthew MacDonald. There's also a great data binding book by Brian
Noyes. Unfortunately, the examples are in C#, but you can download the code
samples in VB.
Good luck.
Robin
"DesCF" <descf@aol.comw rote in message news:op.th1okar kupgxg0@descsta r...Thanks for all that, clears it up nicely. Are there any books out there
on vb.net that anyone would recommend ?
>
>
>
On Thu, 26 Oct 2006 12:56:50 +0100, Jonathan West <jwest@mvps.org wrote:
>>>>
>"DesCF" <descf@aol.comw rote in message
>news:op.th0tso wxupgxg0@descst ar...>>>>What are the differences between vb, vb.net, & vba ?
>>
>They have been obfuscated to an extent by Microsoft, but broadly it is
>this.
>>
>VB is the name given to the older versions of Visual Basic, up to and
>including VB6 which was released in about 1998.
>>
>VB.NET is the name generally given to more recent versions of Visual
>Basic
>released from 2000 onwards, and which make use of the .net framework.
>Although VB.NET is claimed by Microsoft to be an update to VB, they
>aren't
>all that compatible and you should be wary about attempting to port any
>project of significant size from VB6 to any later version.
>>
>The obfuscation creeps in because Microsoft calls the most recent version
>"VB2005", dropping the .net suffix from the name even though it uses the
>VB.NET syntax, not the VB6 syntax.
>>
>VBA (Visual Basic for Applications) is the version of VB that is included
>inside various of the Microsoft Office applications, and is also
>licensed by
>Microsoft for other companies to include within their own applications.
>It
>uses the VB6 syntax and usually makes available a specialised object
>model
>for controlling the host application, and has a simpler forms library
>than
>VB6 (VBA UserForms are simpler and less capable than VB6 Forms).
>General-purpose VB6 code can often be imported into VBA projects and work
>unmodified.
>>
>>
>
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Comment
-
Re: vb, vb.net, & vba
Another thought that just popped into my mind is where does vbscript fit
into this ?
On Thu, 26 Oct 2006 12:56:50 +0100, Jonathan West <jwest@mvps.org wrote:
>
"DesCF" <descf@aol.comw rote in message
news:op.th0tsow xupgxg0@descsta r...>>What are the differences between vb, vb.net, & vba ?
>
They have been obfuscated to an extent by Microsoft, but broadly it is
this.
>
VB is the name given to the older versions of Visual Basic, up to and
including VB6 which was released in about 1998.
>
VB.NET is the name generally given to more recent versions of Visual
Basic
released from 2000 onwards, and which make use of the .net framework.
Although VB.NET is claimed by Microsoft to be an update to VB, they
aren't
all that compatible and you should be wary about attempting to port any
project of significant size from VB6 to any later version.
>
The obfuscation creeps in because Microsoft calls the most recent version
"VB2005", dropping the .net suffix from the name even though it uses the
VB.NET syntax, not the VB6 syntax.
>
VBA (Visual Basic for Applications) is the version of VB that is included
inside various of the Microsoft Office applications, and is also
licensed by
Microsoft for other companies to include within their own applications.
It
uses the VB6 syntax and usually makes available a specialised object
model
for controlling the host application, and has a simpler forms library
than
VB6 (VBA UserForms are simpler and less capable than VB6 Forms).
General-purpose VB6 code can often be imported into VBA projects and work
unmodified.
>
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Comment
-
Re: vb, vb.net, & vba
Personally, I think "Start-to-Finish Visual Basic 2005" is a great book,
not that I'm biased. It will be available mid-November.
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
Thanks for all that, clears it up nicely. Are there any books out
there on vb.net that anyone would recommend ?
Comment
-
Re: vb, vb.net, & vba
I live in Cambridge so I'll check it out when it arrives Tim. Just out of
curiosity since you're here, how much can someone expect to make from
writing a book like this and how easy is it to do ?
On Fri, 27 Oct 2006 15:03:46 +0100, Tim Patrick
<invalid@invali d.com.invalidwr ote:
Personally, I think "Start-to-Finish Visual Basic 2005" is a great book,
not that I'm biased. It will be available mid-November.
>
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
>>>Thanks for all that, clears it up nicely. Are there any books out
>there on vb.net that anyone would recommend ?
>
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Comment
-
Re: vb, vb.net, & vba
Free book from MS: Introducing Microsoft Visual Basic 2005 for Developers
DesCF wrote:I live in Cambridge so I'll check it out when it arrives Tim. Just out
of curiosity since you're here, how much can someone expect to make from
writing a book like this and how easy is it to do ?
>
>
>
>
On Fri, 27 Oct 2006 15:03:46 +0100, Tim Patrick
<invalid@invali d.com.invalidwr ote:
>>>Personally, I think "Start-to-Finish Visual Basic 2005" is a great
>book, not that I'm biased. It will be available mid-November.
>>
>-----
>Tim Patrick
>Start-to-Finish Visual Basic 2005
>>>>>>Thanks for all that, clears it up nicely. Are there any books out
>>there on vb.net that anyone would recommend ?
>>
>
>
--Using Opera's revolutionary e-mail client: http://www.opera.com/mail/Comment
-
Re: vb, vb.net, & vba
You 'll find some information at:
DesCF wrote:Another thought that just popped into my mind is where does vbscript fit
into this ?
>
>
On Thu, 26 Oct 2006 12:56:50 +0100, Jonathan West <jwest@mvps.org wrote:
>>>>
>"DesCF" <descf@aol.comw rote in message
>news:op.th0tso wxupgxg0@descst ar...>>>>What are the differences between vb, vb.net, & vba ?
>>
>They have been obfuscated to an extent by Microsoft, but broadly it is
>this.
>>
>VB is the name given to the older versions of Visual Basic, up to and
>including VB6 which was released in about 1998.
>>
>VB.NET is the name generally given to more recent versions of Visual
>Basic
>released from 2000 onwards, and which make use of the .net framework.
>Although VB.NET is claimed by Microsoft to be an update to VB, they
>aren't
>all that compatible and you should be wary about attempting to port any
>project of significant size from VB6 to any later version.
>>
>The obfuscation creeps in because Microsoft calls the most recent version
>"VB2005", dropping the .net suffix from the name even though it uses the
>VB.NET syntax, not the VB6 syntax.
>>
>VBA (Visual Basic for Applications) is the version of VB that is included
>inside various of the Microsoft Office applications, and is also
>licensed by
>Microsoft for other companies to include within their own
>applications . It
>uses the VB6 syntax and usually makes available a specialised object
>model
>for controlling the host application, and has a simpler forms library
>than
>VB6 (VBA UserForms are simpler and less capable than VB6 Forms).
>General-purpose VB6 code can often be imported into VBA projects and work
>unmodified.
>>
>>
>
>
--Using Opera's revolutionary e-mail client: http://www.opera.com/mail/Comment
-
Re: vb, vb.net, & vba
Although my contracts forbid me from revealing the payment terms for my books,
I can tell you this: As an author, you can expect a life of poverty and sadness,
with fingers warn to the nubs from correcting all of the mistakes you included
in the book. Your eyes glaze over from constantly checking the position of
your book on Amazon.com. And you hide in the corners wondering if everyone
is going to find out that you really aren't an expert on any topic.
In all seriousness, it is a tough job, especially if, like me, you write
in your spare time. And if you calculate the pay per-hour, it's pretty shocking
how little you make. But if you have writing in your blood, you just can't
stop yourself. You think about it all the time, and you love to do it, even
when the benefits seem scarce. I am constantly taking notes for future books
and articles, and it's a joy every time I put ink to paper.
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
I live in Cambridge so I'll check it out when it arrives Tim. Just
out of curiosity since you're here, how much can someone expect to
make from writing a book like this and how easy is it to do ?
>
On Fri, 27 Oct 2006 15:03:46 +0100, Tim Patrick
<invalid@invali d.com.invalidwr ote:
>>Personally, I think "Start-to-Finish Visual Basic 2005" is a great
>book, not that I'm biased. It will be available mid-November.
>>
>-----
>Tim Patrick
>Start-to-Finish Visual Basic 2005>>Thanks for all that, clears it up nicely. Are there any books out
>>there on vb.net that anyone would recommend ?
>>>
Comment
-
Re: vb, vb.net, & vba
That is a good reference, but be aware that it really targets those who already
use an earlier version of Visual Basic .NET. It's not for the true beginner.
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
Free book from MS: Introducing Microsoft Visual Basic 2005 for
Developers
>
http://msdn2.microsoft.com/en-us/vbrun/ms788235.aspx DesCF wrote:
>
Comment
-
Re: vb, vb.net, & vba
It's about time! Your book been on my amazon.com wish list for a couple of
months now. I've been forced to read other books while waiting for this to
come out. I just noticed today that they finally stuck a date of 11/15 on
it. By then, I will have read 3 other books, but I'm still looking forward
to buying this one and working through it. So at least you'll sell one copy.
Maybe you'll eventually make enough $$ to buy yourself lunch somewhere nice,
like Taco Bell. ;-)
Robin
"Tim Patrick" <invalid@invali d.com.invalidwr ote in message
news:e3b469760f 038c8c7ad2e51ce 5c@newsgroups.c omcast.net...Personally, I think "Start-to-Finish Visual Basic 2005" is a great book,
not that I'm biased. It will be available mid-November.
>
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
>>>Thanks for all that, clears it up nicely. Are there any books out
>there on vb.net that anyone would recommend ?
>
Comment
-
Re: vb, vb.net, & vba
Poverty and sadness? What about the joy of being published, of people
picking up your book and reading it at B&N and then putting it back on the
shelf because they're too cheap to buy it? (B&N is NOT a library, people.)
What about the joy of people posting positive reviews on amazon.com because
they've gotten so many wonderful job offers because of the knowledge they've
gained from your book? What about the joy of knowing that somewhere out
there, someone is reading your book and thinking, "I could have done a
better job", but you know everybody *thinks* they can write a book while few
can actually accomplish it? Come on, now, the best stuff in life is free.
(Just ask the guy at B&N. ;-)
Robin
"Tim Patrick" <invalid@invali d.com.invalidwr ote in message
news:e3b469760f a18c8c7f4f2b72f 16@newsgroups.c omcast.net...Although my contracts forbid me from revealing the payment terms for my
books, I can tell you this: As an author, you can expect a life of poverty
and sadness, with fingers warn to the nubs from correcting all of the
mistakes you included in the book. Your eyes glaze over from constantly
checking the position of your book on Amazon.com. And you hide in the
corners wondering if everyone is going to find out that you really aren't
an expert on any topic.
>
In all seriousness, it is a tough job, especially if, like me, you write
in your spare time. And if you calculate the pay per-hour, it's pretty
shocking how little you make. But if you have writing in your blood, you
just can't stop yourself. You think about it all the time, and you love to
do it, even when the benefits seem scarce. I am constantly taking notes
for future books and articles, and it's a joy every time I put ink to
paper.
>
-----
Tim Patrick
Start-to-Finish Visual Basic 2005
>>>I live in Cambridge so I'll check it out when it arrives Tim. Just
>out of curiosity since you're here, how much can someone expect to
>make from writing a book like this and how easy is it to do ?
>>
>On Fri, 27 Oct 2006 15:03:46 +0100, Tim Patrick
><invalid@inval id.com.invalidw rote:
>>>>Personally, I think "Start-to-Finish Visual Basic 2005" is a great
>>book, not that I'm biased. It will be available mid-November.
>>>
>>-----
>>Tim Patrick
>>Start-to-Finish Visual Basic 2005
>>>Thanks for all that, clears it up nicely. Are there any books out
>>>there on vb.net that anyone would recommend ?
>>>>
>
Comment
Comment