What does Visual Basic do?

      An explanation of how Microsoft's Visual Basic for Applications works. June 13, 2001

Question
I have written 20 or so parametric macros for certain part creations using AlphaCAM and they are great. I have no vb knowledge and would like a good description of how they work and what they can do that I can't do now.

Forum Responses
Microsoft's Visual Basic for Applications® (VBA) is the world's most widely used Rapid Applications Development Language. It is built into all Microsoft Office® programs as well as many hundreds of others, covering a wide range of applications, including AutoCAD. VBA works with the core code of software programs into which it is incorporated through an Application Programming Interface (API).

VBA provides two fundamental functions for host programs. First, it enables customization of host programs to enable users to automate processes within such programs and to make them function in a particular way. This functionality is comparable to but very much more powerful than the legacy ‘parametric macro’ function that exists in AlphaCAM. Parametric macros simply use the menu structure to link a series of commands to produce a desired result, allowing for user input during the process. When first offered, this functionality was revolutionary and provided a much-appreciated resource for AlphaCAM. But time has moved on, and VBA now facilitates much greater power and versatility for users. Licom was the first CAD/CAM developer to incorporate VBA and an associated API, and has exposed most of its core functions through that API. Skilled programmers can now do extraordinarily complex things to build on the inherent power of AlphaCAM. But it is not necessary to be a professional programmer to use VBA in AlphaCAM. There is a growing body of users among our many thousands of AlphaCAM enthusiasts around the world who are taking advantage of this power, and either writing fresh VBA macros or converting old parametric macros to VBA format and enhancing their functionality and speed by doing so.

The second advantage of VBA is that it allows full-scale integration between software programs and their data. This means that AlphaCAM is able to work with data from and provide data to external applications such as spreadsheets, databases, cost estimating, and accounting software. The ability to integrate means that order entry systems, inventory management systems, part labeling and bar-coding systems can all work with AlphaCAM. There is now virtually no limit other than the imagination and inventiveness of users as to what can be achieved in this way.

Licom offers an Introduction to VBA training course at our Charlotte Headquarters. We do not, however, attempt to provide comprehensive VBA training since that is not our business and there are many local sources of such training. VBA is now taught in most high schools and colleges and there are many thousands of VBA programmers with the skill to capitalize on what is available in AlphaCAM.



VB/VBA allows you to move data between different programs without manual intervention. VB/VBA also allows the data to be manipulated or stored in a manner that can easily be read or printed for reports.

For example, if you have a process that requires many keystrokes, the keystrokes and the likelihood of mistakes can be eliminated by using a VB/VBA macro, as opposed to doing the same operation over and over manually.

You can also export data from AutoCAD to an Excel spreadsheet to allow parametric functions to be used within Excel, take that data and print a cutlist, then export the data back into AutoCAD and print drawings to be submitted for approval for a job. Many manual tasks are eliminated as well as the chances to make mistakes.

Most current engineering packages allow you to interface fairly easily with VB/VBA.

Just about any of the larger bookstore chains will have books on VB/VBA programming. If there is a community college close by that you have easy access to, they will have courses from entry level on up. Most of the Microsoft certification schools offer venues to teach as well.



Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?


Have you reviewed the related Knowledge Base areas below?
  • KnowledgeBase: Computerization

  • KnowledgeBase: Computerization: Software

  • KnowledgeBase: Knowledge Base


    Would you like to add information to this article? ... Click Here

    If you have a question regarding a Knowledge Base article, your best chance at uncovering an answer is to search the entire Knowledge Base for related articles or to post your question at the appropriate WOODWEB Forum. Before posting your message, be sure to
    review our Forum Guidelines.

    Questions entered in the Knowledge Base Article comment form will not generate responses! A list of WOODWEB Forums can be found at WOODWEB's Site Map.

    When you post your question at the Forum, be sure to include references to the Knowledge Base article that inspired your question. The more information you provide with your question, the better your chances are of receiving responses.

    Return to beginning of article.



    Refer a Friend || Read This Important Information || Site Map || Privacy Policy || Site User Agreement

    Letters, questions or comments? E-Mail us and let us know what you think. Be sure to review our Frequently Asked Questions page.

    Contact us to discuss advertising or to report problems with this site.

    To report a problem, send an e-mail to our Webmaster

    Copyright © 1996-2016 - WOODWEB ® Inc.
    All rights reserved. No part of this publication may be reproduced in any manner without permission of the Editor.
    Review WOODWEB's Copyright Policy.

    The editors, writers, and staff at WOODWEB try to promote safe practices. What is safe for one woodworker under certain conditions may not be safe for others in different circumstances. Readers should undertake the use of materials and methods discussed at WOODWEB after considerate evaluation, and at their own risk.

    WOODWEB, Inc.
    335 Bedell Road
    Montrose, PA 18801

    Contact WOODWEB











  • WOODWEB - the leading resource for professional woodworkers


      Home » Knowledge Base » Knowledge Base Article