Solved

What is VBA?

Posted on 2004-10-21
472 Views
Last Modified: 2010-05-02
Dear Friends
                       
Can anyone explain these things
What is VBA?
What is the difference b/w VBA & VB ?
Is VBA and  vbscript is same?


Regards
Prakash


0
Question by:prakash_prk
    10 Comments
     
    LVL 44

    Assisted Solution

    by:Arthur_Wood
    VBA is Visual Basic For Applications, and is a 'version' of Visual Basic that is used (and licensed by Microsoft) to program other applications (MS Access, MS Word, Lotus Notes, PowerPoint, AutoCad to name a few).  It is a programming language closely related to Visual Basic, with some platform specific limitations and/or features.

    VBA is NOT the same as VBScript

    AW
    0
     
    LVL 76

    Accepted Solution

    by:
    VBA is visual basic for applications. It cannot be used to produce compiled programs, and can only be used from the particular application that hosts it
    The language (syntax) is the same.
    0
     
    LVL 10

    Author Comment

    by:prakash_prk

    Where i can write the code?
    0
     
    LVL 76

    Expert Comment

    by:GrahamSkan
    VBScript is a freestanding uncompiled language and requires a 'host' to interprete it.
    It's language is very similar to VB and VBA, but there are important differences.
    0
     
    LVL 76

    Expert Comment

    by:GrahamSkan
    You write VBA code in Word, Access, Excel or other Microsoft Office applications.

    It can be incorporated into third party-applications as well, but I don't know of an example
    0
     
    LVL 7

    Expert Comment

    by:bkthompson2112
    You can access the VBA editor from Excel, Access, etc.
    by pressing <Alt><F11>
    0
     
    LVL 76

    Expert Comment

    by:GrahamSkan
    Arthur,
    I don't know about Autocad, but Lotus Notes uses LotusScript, which resembles VB(A), but is not the Microsoft product.
    0
     
    LVL 10

    Author Comment

    by:prakash_prk

    Is a macro written in MS Excel is VBA ?
    0
     
    LVL 4

    Assisted Solution

    by:joachimcarrein
    yes it is
    0
     
    LVL 44

    Expert Comment

    by:Arthur_Wood
    LotusScript is Lotus' licensced version of VBA - Microsoft licenses VBA to other vendors so they don't need to 're-invent the wheel'.  Lotus then 'renames' it as LotusScript - makes them feel better I guess.

    AW
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    931 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now