Baarns: Microsoft Excel Frequently Asked Questions - VBA to C DLL Masters Secrets

Secrets for passing a SafeArray to a C-based DLL

The file available below contains excellent sample code revealing the master's secrets for passing a SafeArray to a C-based DLL. It includes two simple VBA routines which call the C code. The C DLL includes both the compiled DLL (for use with the VBA examples) and all source code so you can actually see the inner workings of these routines. Both 16 and 32 bit source code are included.

Also includes a Word document with background concepts that are helpful for creating your own DLLs and understanding OLE SafeArrays.

This demo assumes you are familiar with programming, and if you wish to explore the DLL source code, you should be familiar with programming in C. This is NOT a complete programming course, but an excellent tool for programmers who wish to understand the finer points of VBA to C programming concepts.

Download VBA to C DLL Masters Secrets Sample Code Now!(129K)
Information provided in this document is provided "as is" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The user assumes the entire risk as to the accuracy and the use of this information.
Requires Microsoft Excel 5.0c or higher.

Mental Floss prevents Moral Decay.