Variables Between Workbooks

Greetings,

I have a variable in one workbook that I want any other open workbook
to recognize. For example, workbook A declares variable X. I want
workbook B to also recognize variable X from workbook A.

I am a VBA novice, so please use layman's terms with your reply.

Many thanks,
David

You would need a function in workbookA that would return the value of that
variable

In a general module in WorkbookA.xls
' in the declarations section
Public lngVar as Long

' in the code section
Sub SetVar()
' or some code to set the value of the public variable
lngVar = int(rnd()*1000+1)
End Sub

Public Function MyVariable()
MyVariable = lngVar
End Function

then in the other workbooks you can do

lngA = Application.Run("WorkbookA.xls!MyVariable")

--
Regards,
Tom Ogilvy

<bobsacomano@yahoo.com> wrote in message
news:1116981600.364629.13150@g49g2000cwa.googlegroups.com...
> Greetings,
>
> I have a variable in one workbook that I want any other open workbook
> to recognize. For example, workbook A declares variable X. I want
> workbook B to also recognize variable X from workbook A.
>
> I am a VBA novice, so please use layman's terms with your reply.
>
> Many thanks,
> David
>