What are the differences between VBA and VB 6.0????

[Paladyr]

I am currently putting in a proposal to have my department purchase VB 6.0 for my use at work, but in the past week, I have been using VBA a lot and am wondering if it would still be worth it to purchase VB 6.0??? Can VBA do everything VB 6.0 can? I have Office 2000. I personally prefer doing things in VB 6.0 since Access has some limits on how many subforms you can have and also you have to have info in the child form and info in the parent form instead of putting them anywhere you want. Any help would be appreciated! Also, there are different versions of VB 6.0 so which one should I get? Thanks!

 

[Paladyr]

Bump, I really need help on this!!!

 

[TRYP]

vba can not make an executable
vb can

vb is easier for a coder to do what they have to do to
vba forces tedious workarounds
example:
vb can clear a combo box
vba can only let you requery

vba requires the user to have some form of MS Office product
vb does not

vb apps are cleaner
vba apps have ... well Office

hope this helps
TRYP

 

[Paladyr]

Thank you very much, it did!!!!

 

[VogonPoet]

One thought-

If you get the enterprise edition of VB6, you can create your own DLLs. This is a nice way to share commonly used functions and procedures among programs.

 

[WhiteTiger]

Mainly VBA is just like, little added functions etc to do things within that specific program, you can't over look other applications.

We use VBA in Autocad 2000 here in the office, and holy crap, with the tools we've made, weve increased the productivity and it's equal to about 5 peoples paychecks. Regards,
Anthny
----------------------------------------
"You say [red]insanity[/red] like it's a BAD THING!"