Calling functions in another workbook or XLA module

[dfein]

How do you call a function in another workbook and get back its result. TO call a sub you can use applicationl.run "xlsfile!modname", what the syntax for calling a function?

Thanks,
David Fein

[Ivan F Moala]

On 2002-05-22 08:36, dfein wrote:
How do you call a function in another workbook and get back its result. TO call a sub you can use applicationl.run "xlsfile!modname", what the syntax for calling a function?

Thanks,
David Fein

David try;

Application.Run "Myfile!myfilefunc", "A1:A10"

Just specify the paramters its expecting
in this case a range.

[dfein]

That calls the function and passes the param, but how do you get the result back?

[Ivan F Moala]

On 2002-05-22 08:51, dfein wrote:
That calls the function and passes the param, but how do you get the result back?

Assign it to a variable

eg MyValue = ......