VBA vs. VB6?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhino - 14 Feb 2006 21:15 GMT

I'm just curious: how similar/different are VBA and Visual Basic 6?

I'm more or less functional in VBA at this point and have just seen a job
posting where Visual Basic 6 is a "nice to have". I'm wondering if it would
be reasonable to cite my experience with VBA as proof that VB6 would not be
a big challenge?

Or are they totally different animals?

Signature

Rhino

Reply to this Message

Jonathan West - 14 Feb 2006 21:34 GMT

> I'm just curious: how similar/different are VBA and Visual Basic 6?
>
[quoted text clipped - 4 lines]
>
> Or are they totally different animals?

The language is essentially the same. VB6 Forms are a bit more complex and
capable than VBA UserForms, but its pretty much the same idea. You'll need
to read up on the different kinds of projects you can build in VB6.
Controlling Word from a VB6 app is very similar to doing it from within VBA.

Almost everything else is a matter of what references you set in order to
gain access to different object models, and is essentially identical for
both VBA and VB6. If you need help on VB6, the group to ask in is
microsoft.public.vb.general.discussion.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Ishai Sagi - 14 Feb 2006 23:44 GMT

There are some things that a VBA developer just doesnt know - for
example, creating DLL files and designing the achitecture, and
deployment.

If you are a VBA developer and am not familiar with the above, you are
going to have issues...
also, some VBA developers dont even know how to referance and use
external dll's, and are only familiar with office object model. if you
havent used other objects, you should get more expirience before
introducing yourself as a VB developer

Reply to this Message