run vba function from different xls file

[bestox]

i would like to run a function from another file (in the same directory) and want to save the return value (it s a string) to a local string variable.

unfortunately, this

dim x as string
x = Run "'filename.xls'!Modul1.update"

does not work.

what code do i need, to save the result of the function to my variable x?

thank you!

 

[Alteran]

Have you tryed getting the file to open your other file and running the script with a call function?

 

[Alteran]

This link explains how to do it:

http://www.mrexcel.com/archive/VBA/3338.html

 

[bestox]

my mistake.

this works:

Run "'filename.xls'!Modul1.update"

but this does not work:

dim x as string
x = Run "'filename.xls'!Modul1.update"

 

[bestox]

maybe is should add, that function update looks like that:

Function update() As String

 

[RoryA]

dim x as string
x = Application.Run("'filename.xls'!Modul1.update")

should do it.

 

[bestox]

jep this is it, thank s.

thank you alteran too!