API ResourcesThis content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
To call functions in the Microsoft® Windows® API, or any API for that matter, you must have documentation describing the available functions, how to declare them in VBA, and how to call them. Two helpful resources are:
- The Win32API.txt file included in Microsoft® Office XP Developer and in Microsoft® Visual Basic®. The Win32API.txt file contains VBA Declare statements for most of the functions in the Windows API.
- The Microsoft Platform SDK, which contains complete documentation for the Windows API. It is available free of charge on the Microsoft® Developer Network (MSDN®) Web site at http://msdn.microsoft.com.