How to share variable values between 2 Workbooks ?
 

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

Yves Le Hurt

How to share variable values between 2 Workbooks ?
 

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 wrote in message
...
Hi,
Does anyone know how to do this ?
Thanks in advance for your help.

Yves Le Hurt

How to share variable values between 2 Workbooks ?
 

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 wrote in message
...
Hi,
Does anyone know how to do this ?
Thanks in advance for your help.

Yves Le Hurt