Cindy
Sat Dec 06 04:46:01 CST 2003
Hi VBA,
> Very strange that there is this difference
> between VB, VBA for Access and VBA for Word.
>
They use different forms packages, is why. Back in the dark
past, VB already existed as a separate thing; Word had
WordBasic and Excel its own macro language; Access was
developed as a totally separate application.
Marketing came along in 1993 or so and said, let's bundle
Access, Excel, Word and Powerpoint as an "Office Suite" in
order to get people to buy all our products, instead of
Lotus 1-2-3, WordPerfect, Harvard Graphics and dBase.
Eventually, the Excel, Word and Powerpoint (in that order)
were trimmed to use VBA. VBA bases on the VB language, but
doesn't use all the functionality of VB. And the forms
package with its ActiveX controls is totally independent of
what VB uses. AccessBasic eventually mutated to VBA, but it
kept its own Forms package, that was developed specifically
for Access-related tasks.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)