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

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

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

"Bura Tino" wrote:

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.

--
http://ManagedXLL.net/
Replace MSDN with my first name when replying to my email address!