Programming Excel with VBA: A Practical Real-World Guide

© © The Editor(s) (if applicable) and The Author(s) 2016

Flavio Morgado, Programming Excel with VBA, 10.1007/978-1-4842-2205-8_10

10. Using the Windows API

Flavio Morgado¹ 

(1)Rio de Janeiro, Brazil

Now that you have a good understanding of VBA and how to use it to produce good interfaces to your worksheet applications, it is time to expand this knowledge to the unknown, incomprehensible world of the Windows application programming interface (API) that makes Microsoft Windows work.

Why should you care about it? For one simple reason: by using the Windows API, you can extend VBA capabilities to the next level, doing programming tricks that you see in other software interfaces and that you can’t do using just the regular VBA language.

In this chapter, ...