Simon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Excel VBA: Declare statement to reference an external procedure
Having completed the VBA advanced course, I am gradually getting to grips with inherited code and code that I have plagiarized because it worked, but that I did not really understand.
One example is this
RE: Excel VBA: Declare statement to reference an external proced
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
