VBA is a subset of VB which runs inside one of the office applications. As a result VBA inherits the current Office object library and application instance by default and any references that are included. However in VB you have to create the application instances if you need to manipulate one or more of the Office application objects.
There is not much difference between VBA and VB as such. VBA may be thought of cut down version of VB and is primarily used for programming in Office Application such as Word, Excel, Outlook etc. However, VB has wide scope for programming.
Syntax wise also there is not much difference, You may try to take this code in VB directly and try to run that. That might work?
No comments:
Post a Comment