Application.Run and return result from a function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Flemming Dahl - 01 Dec 2004 17:45 GMT

Hi all,

I am using Application.Run to run a Sub from a global add-in, and this works
fine.
Application.Run "Module.SubName", "Parameter"

But I when it comes to run a function and get the result back, I am trying
this:
MyString = Application.Run "Module.FunctionName", "Parameter"

Am I doing it the right way? or can't I get the result return?

Thanks,
Flemming

Reply to this Message

Peter - 01 Dec 2004 18:00 GMT

You have the right idea, now just wrap the parameters to Application.Run in parentheses:

MyString = Application.Run("Module.FunctionName", "Parameter")

hth,

-Peter

> Hi all,
>
[quoted text clipped - 10 lines]
> Thanks,
> Flemming

Reply to this Message

Flemming Dahl - 01 Dec 2004 18:02 GMT

Hi Peter

Yes I just found out - how blind can one be :-)

Thanks
Flemming

You have the right idea, now just wrap the parameters to Application.Run in
parentheses:

MyString = Application.Run("Module.FunctionName", "Parameter")

hth,

-Peter

> Hi all,
>
[quoted text clipped - 10 lines]
> Thanks,
> Flemming

Reply to this Message

Peter - 01 Dec 2004 18:40 GMT

> Hi Peter
>
> Yes I just found out - how blind can one be :-)

I don't know, I keep pushing the limits. :-)

Reply to this Message

Rate this thread: