VBA vs. VB6?

R

Rhino

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?
 
J

Jonathan West

Rhino said:
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?


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.


--
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
 
I

Ishai Sagi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top