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

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

Main Question or Discussion Point

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 any one 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,790
131
  • #3
783
9
chiro, no I didn't come across that one. Thank. I will see if I can use that.
 
  • #4
783
9
Yes, that methods works perfect. Sorry for the very slow response.
 

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

  • Last Post
2
Replies
29
Views
67K
Replies
16
Views
3K
  • Last Post
Replies
8
Views
41K
Replies
5
Views
4K
Replies
1
Views
5K
Replies
5
Views
4K
Replies
5
Views
2K
Top