Using a function from my own c++ add-in in vba.

[Bura Tino]

Hi,

This is a repost of a recent message by me, but this one has a more relevant
subject, so I'm hoping it will get more of a response.

I have defined a function in my C++ which takes a string and returns a
string. It takes a URL and returns the content of the resource. Its
"REGISTER" parameters are these:

static LPSTR func[][14] = {
{ " getURL" , " RP" , " getURL" , " URL String" , " 1", " MyAddin", " ", ...

It works in worksheets flawlessly. What declaration do I need to make to
make it work in vba?

Many thanks in advance!

Bura

 

[Jens Thiel]

I have defined a function in my C++ which takes a string and returns a
string. It takes a URL and returns the content of the resource. Its
"REGISTER" parameters are these:

static LPSTR func[][14] = {
{ " getURL" , " RP" , " getURL" , " URL String" , " 1", " MyAddin", " ", ....

It works in worksheets flawlessly. What declaration do I need to make to
make it work in vba?

Try MyVariant = Application.Run("getURL", "http://ManagedXLL.net/").

Jens.