Links.md

Links

Links containing useful

General Random

• Tips and Tricks

General Advanced

• New style blog - Excel Development Platform
• Free VB Code

---

Books

• McKinney's - Hardcore vba

---

Excel 4.0 Macro Language

• Reference

---

VB6 Attributes

• Attribute keyword info

---

VB6 MULTITHREADING:

• The trick's VB6 multithreading with Kernel32::CreateThread
• A thread to Visual Basic: Multi-Threading in VB5 and VB6
• Multithreading System - Note I think this requires an external DLL.

---

ENUM Running Object Table (ROT):

• Last Post - Via Type library
• VB.NET Approach
• Tom Schreiner's code for iterating through AutoCAD instances
• C# example
• AHK Example
• COM Object from Moniker name in ROT

---

COM Talk:

General Concepts:

• Ext: Introduction to COM for VB programmers
• MSDN: IDispatchEx
• MSDN: DISP IDs i.e. VB_UserMemID

Libraries:

• VBF: DLL / COM object generalised function caller
• VBF: Creating and Using COM interfaces without TypeLibraries
• FVBC: Determine if a property exists on a COM object
• VBF: DISPID_EVALUATE
• VBF: Analysis of type library

---

Structs / UDTs

• Serializing COM objects

---

Collections/Dictionaries

• Quick acces collections/dictionaries

• Extensions to Dictionary: E.G. Sort, GetHash, GetItems, ...

Machine Code:

• Execute MCode (OPCodes) from VB6

Non VBA Resources:

Excel C API

• Could be useful for working with type libraries