Read & Write Reviews About The Tools You Use.
Sign up for free to start sharing your opinion today!

User Reviews

Share:

• 
  

  Version Reviewing: 6.0

  "VBA Important Limitations"

  by upender on Feb 21, 2012 8:38 AM

  Summary:
  That is the good.On a side note, VBA macros can (obviously) be created with a malicious intent. Using VBA, most of the security features lie in the hands of the user, not the author. The VBA 'host-application' options are accessible to the user. The user who runs any document containing VBA macros can preset the software with user preferences, much like those for web browsers. End-users

  Report post

  Was this review helpful? (0) (0)

  Must be logged in to comment

• 
  

  Version Reviewing: 6.0

  "VBA Functionally Rich, but has Important Limitations"

  by edd on Aug 30, 2011 5:36 PM

  Summary:
  VBA is functionally rich and flexible but it does have some important limitations, such as restricted support for function pointers which are used as callback functions in the Windows API. It has the ability to use (but not create) (ActiveX/COM) DLLs, and later versions add support for class modules. When designing an application building project, and choosing a correct tool for the job, these considerations should be kept in mind. On a side note, VBA macros can (obviously) be created with a malicious intent. Using VBA, most of the security features lie in the hands of the user, not the author. The VBA 'host-application' options are accessible to the user. The user who runs any document containing VBA macros can preset the software with user preferences, much like those for web browsers. End-users can protect themselves from attack by disabling macros from running in an application if they do not intend to use documents containing them, or only grant permission for a document to run VBA code if they are sure the source of the document can be trusted. However, some VBA macros can disable the user’s option to intervene in the running of the malicious code immediately when a program containing the macro is opened, and the consequences of this process are obviously dangerous.

  Report post

  Was this review helpful? (1) (0)

  Must be logged in to comment

• 
  

  Version Reviewing: 6

  "VBA: The Good, The Bad & The Ugly"

  by Ben_msft_314R2 on Aug 29, 2011 8:11 PM

  Summary:
  I think that Visual Basic for Applications (VBA) 6.0 is a good program, with some good qualities, and a number of significant limitations. On the positive side, VBA is a robust, object-oriented, sophisticated and powerful development platform, ideally suited for producing impressive Windows applications. The Visual Basic syntax forms the core of the scripting languages built into all the Microsoft applications like Word, Excel, Power Point, Access and others. VB certainly has its advantages: • It is a powerful and complete Windows application development system that enables us to use built-in functions and subroutines for dozens of different tasks. • It also provides capability to produce custom libraries and objects that can be loaded at runtime or bound into the distributed application. • It is a hugely successful product preferred by millions of developers at virtually all skill levels. • It is well supported by third party products • It supports the principle of object driven design • It is very flexible and user-friendly as it is a GUI (Graphic User Interface) That is the good. It’s likely for these and other reasons that VBA garners much attention and admiration from application builders. And VBA is very useful – right up until it isn’t. And that point typically comes up when trying to make non-Microsoft software interoperate with MS Office products. That is the bad. And now for the ugly: when the application builder realizes that many of the most useful applications, and many of the applications that are most needed, require exactly this type of Microsoft and non-Microsoft interaction and interoperation. And it is here where VBA really starts to pose significant problems to the developer, and where it limitations and inherent problems start to become more glaringly obvious. The verdict: as far as application building goes, this is a great language to start with, but as the requirements become more sophisticated (which they invariably will), I would recommend Borland Delphi as a vastly better alternative.

  Report post

  Was this review helpful? (0) (0)

  Must be logged in to comment

Write a Review

Must be registered to add and review tools.

public class Demo { 
    public void method1() { 
        synchronized (String.class) { 
            System.out.println("on String.class object");       
            synchronized (Integer.class) { 
                System.out.println("on Integer.class object"); 
            } 
        } 
    }