VBA Compatibility with Microsoft® Office 2010
VBA (Visual Basic for Applications) is a framework to develop Microsoft Office 2010 applications. The VBA users can develop custom applications and user interface modules for Microsoft Office 2010. With VBA in Microsoft Office 2010 you can easily do many jobs like adding macros for doing repetitive work. Some of the aspects of VBA in Microsoft Office 2010 are as follows:
- Compatible with Windows operating systems
- Code Inspector
- Inspection of Visual Basic code
- Inspection of VBA code
- Add-on compatibility
Compatible with Windows operating systems
VBA is fully compatible with Windows operating systems, like Windows XP. Microsoft has given due notice to the compatibility issues of VBA and has produced a platform which is not only compatible with the architecture of Windows, but is also very stable when running in them. This is the best part of VBA in Microsoft Office 2010, making it truly accessible to a huge number of users.
Code Inspector
Microsoft Office 2010 Application Compatibility program has a Code Inspector to check for compatibility of codes with respect to the two basic areas, namely, Inspection of VBA code and Inspection of Visual Basic code. The Code Inspector makes it easy to check for compatibility issues and thus prevent future problems with the applications. The Code Inspector is efficient and can also inspect many lines in a short amount of time.
In this case, Microsoft Office 2010 Application Compatibility program with the Coder Inspector checks for compatibility issues line by line. It checks for syntax issues and other line errors. It can be compared to module testing and each line is taken as an individual module and tested thoroughly.
In this case, Microsoft Office 2010 Application Compatibility program with the Coder Inspector check for compatibility issues in view of the overall architecture of the application. This type of checking can be compared to integration testing where modules are checked for compatibility with each other and with the external system, that is, the operating system in this case. It is more complex and requires more time for the Code Inspector to perform this check.
VBA supports the use of add-ons meant for Microsoft Office 2007 to be used in Microsoft Office 2010. Special stress is given to the reusability of Microsoft Excel plugins in Microsoft Office 2010. Now, even the 64-bit versions are expected to run in the 32-bit environment.
iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 can provide the best issue resolution and customer satisfaction. Our award winning and low priced Annual Subscription covers the following services:
- Comprehensive support for VBA in Microsoft Office 2010
- Diagnosis & repair of your hardware issues
- Troubleshoot software errors
- Update drivers and security to protect against online threats
- Connect to Internet, devices and peripherals
- Optimize your computer’s speed and performance
















This tool only appears to integrate with MS Excel, MS word and MS Powerpoint. I am interested in checking VBA code associated with earlier versions of MS Access. Is there a tool that integrates with MS Access to do this and if so where can I obtain it?