A curated list of awesome VBA/VB6 frameworks, libraries, software and resources
Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 (VB6) built into most desktop Microsoft Office applications.
This is a curated list of Libraries and Resources for both VBA and VB6.
Because of the nature of VBA, many libraries do not work on all Operating Systems, in all Office Applications or in all architectures(x64/x86). Some libraries may also require external resources (DLL, Addins, etc.) which can be difficult to use due to VBA's lack of a package manager. To help you in finding projects suitable for your needs, this awesome list uses the following symbology. The symbology also has tooltips which may provide more information.
.dll
, .ocx
, .o
, etc.ConnectToConnectionPoint
API. Also worth looking at this class too.Application.OnTime
(and/or you need to run it faster than once per second), this is the class for you! Also check out the forum post for more information.canvas
like element where any image can be drawn to. Additionally check out this GDI32 class from the same author.PictureBox
compatible substitute, but an extremely performant graph control regardless.STDCALL
and CDECL
.end
in an unhandled error; You click the VBA stop button; You enter design mode; Application exits.vbWatchdog
hacks the VBA runtime to provide module name, procedure name and line number where error occurred.IAccessible
, which not only can be used to automate the UI, but can also be used to obtain the Excel Instance from a hwnd.IDispatch
, Variant
, For each
and With
. It also discusses the dreaded Date bug ported to Excel from Lotus 123.Хакер
. Details the composition of the VB6 and VBA dlls in amongst the history of the language.Хакер
which estimates the number of lines of code in VB6/VBA.Your contributions are always welcome! Please take a look at the contribution guidelines first.