Application.Run and return result from a function

[Flemming Dahl]

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

 

[Peter]

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

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

hth,

-Peter

 

[Flemming Dahl]

Hi Peter

Yes I just found out - how blind can one be

Thanks
Flemming


"Peter" <peterguy -at- hotmail -dot- com> wrote in message
You have the right idea, now just wrap the parameters to Application.Run in
parentheses:

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

hth,

-Peter

 

[Peter]

Hi Peter

Yes I just found out - how blind can one be

I don't know, I keep pushing the limits.