Excel VBA: Declare statement to reference an external procedure

Hi Simon

Thank you for your question


This whole topic centres around programming with windows API. This is quiet involved and too big a subject to be given detailed coverage here. To answer your questions

1. GetSystemMetrics32 is an API function that determines the screen resolution. API stands for Application Programming Interface, and is a tool that allows us to view and modify certain windows settings. It comprises a collection of .DLL files.
Thus we are working with the operating system instead of an application.

2. There are a variety of text books that cover the topic. I for instance use "Excel 2003 VBA" , publisher wrox. www.wrox.com , this will give you an idea as to when they can be used.

3. The alias is used at module level to declare references to external procedures in a dynamic-link library (DLL).

4. The & in the variable is part of the naming convention

Hope this is useful

Regards

Stephen