I tried

local_Var = [Book2.xls]gb_To_Be_Read_From_Outside

from Book1.xls

I know it looks stupid, but need some way to do it, please help.

in the book with the variable, in a general module (in this case, Book2.xls)

Public MVar as Variant

' Place holder
sub InitMyVar()
MyVar = int(rnd()*1000+1)
End Sub

Function ReturnMyVar()
ReturnMyVar = Myvar
End function

Myvar should be initialized or assigned a value some how - assume that is
taken care off

To get the value,

localVar = Application.Run("Book2.xls!ReturnMyVar")

--
Regards,
Tom Ogilvy


" wrote:

I tried

local_Var = [Book2.xls]gb_To_Be_Read_From_Outside

from Book1.xls

I know it looks stupid, but need some way to do it, please help.