|
Many powerful functions not available within the VBA language are available as part of
Windows itself. The Windows API (Application Programming Interface) refers to the nearly
1,000 Windows functions Microsoft exposes for use by Access programmers. You can't take
advantage of these functions from an Access macro; however, by using VBA code, you can
declare and call these functions, improving both the performance and functionality of your
applications.
DDE (Dynamic Data Exchange) and Automation enable you to communicate between your
Access applications and other applications. Although DDE is an older technology than
Automation, it's still used to communicate with a few applications that don't support
Automation. Automation is used to control Automation server applications, such as Excel and
Project, and their objects (all Microsoft Office applications are Automation servers).
Although macros can offer a quick fix to a simple problem, their limitations make the VBA
language the only real option for developing complex solutions. To make the transition from
macros to modules easier, Microsoft has given you a feature that enables you to convert
any macro to VBA code.
End of this subject
|
|
