The information here is applicable to the DLLs supplied with CLW6I09DAL.
Support files for Visual Basic for Applications 7.0 (VBA7) may be found may be found in this zip file. These files can be used in 64-bit VBA7 code. Separate 64-bit VB.NET headers and 32-bit VB6/VBA headers are available.
For each NAG C Library chapter letter there is a file called clvba764-<chapter letter>.bas which contains the VB declarations of the C functions from all the chapters beginning with this letter. For example, clvba764-e.bas contains the declarations of all the functions from the chapters e01, e02, e04 and e05. There is also a corresponding set of files called clvba764-<chapter letter>-long.bas using NAG C Library long names. The supplied files also contain commented out skeletons for call-back functions. All Enum and Type declarations necessary for the parameters (mandatory and optional) can be found in the file clvba764-types.bas. The file clvba764-utilities.bas contains declarations of the Windows kernel function RtlMoveMemory and its aliases. This function is used to copy memory between C pointers and VB variables or arrays. clvba764-*.bas files can be imported into your VB project.
The header files are based on the stand-alone version of the NAG C Library DLL (CLW6I09DA_nag.dll); to specify the version of the DLL which uses the MKL BLAS/LAPACK instead (CLW6I09DA_mkl.dll), replace CLW6I09DA_nag.dll by CLW6I09DA_mkl.dll in the Function and Sub declarations.
See the pages on using the NAG C DLLs from 64-bit Excel for information on how to use these headers.