| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| share and merge workbooks | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Can 2 workbooks share data in Name Fields? | Excel Programming | |||
| Sharing variable values between open workbooks? | Excel Programming | |||
| Sharing Variable Values Between Workbooks??? Any ideas? | Excel Programming | |||
Hybrid Mode
