what is VBA

[pramodrepaka]

Can any on explain me. what is the use of VBA

[vijaydiwakar]

Can any on explain me. what is the use of VBA

VBA= visual basic for application
its used for communication between application like vb with word
Good Luck

[I Hate My Computer]

VBA= visual basic for application
its used for communication between application like vb with word
Good Luck

He is correct but it is used for macro programing although people have found better uses like games.

[AI Man]

VBA (Visual Basic For Applications) is a rather simple computer language Microsoft developed. Its original purpose was to allow users of Windows applications to create more advanced applications. This in turn snowballed into a language that is widely used and very flexible.

For example, using VBA - or VB if you prefer - I can run an Access program that opens Excel spreadsheets, runs Excel macros or saves data in Word, Excel, Access or even as PDF.

Using VBA you can also do things like create pictures via JPEG, add motion or animation to a program. Corel Draw is a more popular program that uses VBA to draw. VBA can also be used to create voices for computers, create CD players or music recorders, create and play games and a number of other functions.

Get down the basics of VBA and life is much easier. Here is a link to some basic VBA stuff that will help you get a taste of what its capable of doing. This link is specificly aimed at Excel, but still a good starting spot to get familiar with VB.

http://msdn2.microsoft.com/en-us/library/aa203714(office.11).aspx

[Killer42]

Or to put it another way...

VB
Development environment/language with compiler to produce "standalone" programs/DLLs (they actually require some runtime stuff, so aren't really independent).

VBA
Basically the same language, without the compiler, built into various MS Office applications such as Word, Excel, Access. Mostly used to build "macros" to do things within the application, though it can do more.

[Dököll]

If you are a VB fanatic, you will be happy to hear most of your VB coding can be converted to VBA, not as easy from VBA to VB. Posted a link here on this, please search this forum if you need to know more.

Have fun!