0 votes
in VBA by Beginner (65 points)
I see in this section a lot of great functions declared by DLLs, and I wonder how to detect them? Where can I get a list of all those functions? How can I create one?

1 Answer

+1 vote
by Expert (911 points)
selected by
Best answer

You can start with Microsoft's Programming Reference for the Win32 API.

Dennis Wallentin's Windows API Viewer for MS Excel can be used to search for a function by keyword. For example, you might search for functions related to monitor or printer or desktop. When you find one that looks interesting, you can use Google to search for the related Microsoft documentation.

My Excel Toolbox includes a module named M_WinAPI that has a limited set of Windows API declarations for use by other procedures in the toolbox project.

When you post a question, please oblige us by responding to comments and answers.

by Beginner (65 points)

In "Microsoft's Programming Reference for the Win32 API", I can not find examples or explanations for Visual Basic, only for C and C ++

by Expert (911 points)

Please don't shout.

The Microsoft documents for Win32 API procedures use .NET nomenclature for Syntax but also define Parameters and Return Values. You must translate the Syntax using a VBA Declare statement. See this recent VBA Q&A  discussion for more on that subject.

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.