How to share variable values between 2 Workbooks ?

[Yves Le Hurt]

Hi,
Does anyone know how to do this ?
Thanks in advance for your help.

Yves Le Hurt

[Tom Ogilvy]

Use one workbook as the source of the varialble value. Link a cell/cells in
the second workbook to the cell/cells in the first workbook with these
values.



--
Regards,
Tom Ogilvy

"Yves Le Hurt" <Yves Le Hurt@discussions.microsoft.com> wrote in message
news:7C2B09C6-BBEE-4163-9318-F26BC30ED98D@microsoft.com...
> Hi,
> Does anyone know how to do this ?
> Thanks in advance for your help.
>
> Yves Le Hurt

[Norman Jones]

Hi Yves,

Try something like:

'=============>>
Public Sub Tester0401()
Dim myVar

myVar = 100

Application.Run "'Book2.xls'!myMacroName", myVar

End Sub
'<<=============


---
Regards,
Norman


"Yves Le Hurt" <Yves Le Hurt@discussions.microsoft.com> wrote in message
news:7C2B09C6-BBEE-4163-9318-F26BC30ED98D@microsoft.com...
> Hi,
> Does anyone know how to do this ?
> Thanks in advance for your help.
>
> Yves Le Hurt