API Resources

  • Article

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 https://msdn.microsoft.com/default.asp.

See Also

API Basics | What Is an API? | Why Use VBA to Call the Windows API? | Accessing Functions in a DLL | Anatomy of a Declare Statement | Constants and User-Defined Types | Understanding Handles