C++ Programming for Financial Engineering
Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!

Python for Finance with Intro to Data Science
Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!

An Intuition-Based Options Primer for FE
Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Reply to thread

Message: <blockquote data-quote="Ilya W" data-source="post: 2117" data-attributes="member: 26">Hi Bridget,My name is Ilya I'm a part time student on the program since september 2004. I'm working on the same problem now, and can show you simple example how to integrate c++ dll file and vba excel. I'm working with c++.net and vba embedded in excel 2003. Here is simple method how to import one dimensional array from VBA to C++ and process it there. At least you will have some idea how to work with it. C++ CODE: 1. open empty windows 32 project2. insert new .h file and call it MyDll.h3. insert .DEF file which links your c++ functions with VBA functions MyDll.Def4. insert .cpp file MyDll.cpp you can send array from VBA to C++ using the first element of array on VB side or using SAFEARRAY structure, here is simple example also in VB and C++ Double have the same size, but integer in VB is short in C++ [code]//prototype in MyDll.h#include <windows.h>short __stdcall Double_Array(double *arr, short size); //MyDll.DefEXPORTDouble_Array //MyDll.cpp simple code to change all elements to 3short __stdcall Double_Array(double *arr, short size){int i;for (i=0; i<size; i++)arr[I]=3;return(0);}[/code] VBA CODE: [code=vba]Option Explicit 'path to libraryPrivate Declare Function Double_Array _Lib "C:your_path\MyStDll.dll" (ByRef arr As Double, ByVal size As Integer) As Integer Private Sub Command1_Click()Dim arr(1 To 5) as Double, lbsum As Double, lasum As DoubleDim arr_size as Integer, k as Integer, i As Integerarr(1) = 2arr(2) = 2arr(3) = 2arr(4) = 2arr(5) = 2 'Sum before call to c++For i = 1 To UBound(arr)lbsum = lbsum + arr(i)Next i arr_size = CInt(UBound(arr()))k = Double_Array(arr(1), arr_size) 'Sum after call to c++For i = 1 To UBound(arr)lasum = lasum + arr(i)Next iMsgBox "Sum of the elements before= " & lbsum & " " & _"Sum of the elements after= " & lasumEnd Sub[/code]good luck</blockquote>

Verification