VB vs VBA ??

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi, can anyone tell me the significant differences
between VB & VBA ? Specifically as pretty much everyone
on the plannet has Excel why would you choose to develop
and roll out something in VB specifically when you have
essentially all the same functionality in Excel ?
 
Oh, goodness, no. VB can create a stand-alone application that requires NO
application in which to run it, such as Excel. People use this primarily (I
suppose) to create proprietary software. Suppose I wanted to develop some
really cool thing that gets stock data from the web. Well, any decent coder
could crack my Excel application and steal my code! So, I need to hire a VB
programmer to make the application stand-alone, and then we don't give the
users the *source code*. That's why, if you ever buy an app, make sure you
get the source code. VBA only works in a very few applications--Office,
Visio, AutoCad, CorelDraw, and I imagine a few others. But an application
created in VB could work on virtually any PC. Let's suppose I wanted to make
an application for quilters to calculate fabric yardage. I'd sell a lot more
of them if I didn't require that the ladies buy Excel, right? VBA is a
mini-version of VB that works with the objects, methods, and properties of
Excel (or whatever its host app). In VB, as I understand it, you create the
objects...
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
 
VB has access to all of an application's object via automation (as long as
the application supports automation).

The crucial difference is that VB can run as a stand-alone, VBA needs a host
application to run it (such as Excel). So if you write some VBA code that
doesn't touch Excel's objects, you still need that host container to run it.
 
Back
Top