Passing a VBA array to a C++ dll - Example Needed

  • C/C++
  • Thread starter CFDFEAGURU
  • Start date
  • #1
CFDFEAGURU
783
9
Hi all,

In the book "Financial Applications Using Excel add-in Development in C/C++" 2nd edition by Steve Dalton in Section 3.7.2 Passing arrays and ranges from Excel to VBA to C/C++ and in that section a description of how this can be done is given. No example of how to do this is given and he refers to an "example.dll" that isn't provided. This book is horrible written but seems to have all the information buried in it some where.

Could anyone provide a simple example of how to pass a 1-D array or vector from VBA to C++ then do a simple operation on the passed array values and then return the array values to VBA?

Thanks.
 

Answers and Replies

  • #2
chiro
Science Advisor
4,815
134
Hey CFDFEAGURU.

Have you seen this?

http://support.microsoft.com/kb/207931
 
  • #3
CFDFEAGURU
783
9
chiro, no I didn't come across that one. Thank. I will see if I can use that.
 
  • #4
CFDFEAGURU
783
9
Yes, that methods works perfect. Sorry for the very slow response.
 

Suggested for: Passing a VBA array to a C++ dll - Example Needed

Replies
34
Views
1K
Replies
20
Views
972
  • Last Post
Replies
2
Views
340
Replies
20
Views
782
  • Last Post
Replies
8
Views
950
Replies
1
Views
513
Replies
32
Views
1K
Replies
15
Views
258
  • Last Post
Replies
23
Views
568
Top