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.