Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA: Declare statement to reference an external procedure
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel VBA: Declare statement to reference an external procedure
Resolved · Low Priority · Version 2003
Reply Thu 21 May 2009, 12:20Delegate Simon said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Wed 27 May 2009, 00:25Delegate Simon said...
RE: Excel VBA: Declare statement to reference an external proced
Thanks Stephen.
It's useful to know what I don't know, so to speak.
I notice that "Excel 2003 VBA Programmer's Reference" at WROX has a section on API.
Cheers,
S!
|