By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,783 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,783 IT Pros & Developers. It's quick & easy.

what is VBA

P: 21
Can any on explain me. what is the use of VBA
Apr 4 '07 #1
Share this Question
Share on Google+
5 Replies


vijaydiwakar
100+
P: 579
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
Apr 4 '07 #2

P: 44
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.
Apr 4 '07 #3

P: 5
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
Apr 4 '07 #4

Expert 5K+
P: 8,434
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.
Apr 5 '07 #5

Dököll
Expert 100+
P: 2,364
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!
Apr 7 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.