Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use variable across workbooks
Hello. I have a workbook with a click event. The click event opens another
workbook and runs a procedure in the newly opened workbook. I would like to read the contents of of Sheet1, cell A1 in the file that houses the click event, and be able to use that variable in the code in the workbook that the click event opened. Can this be done?? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use variable across workbooks
Yes you can; you'll get the idea from this:
workbooks("Book1").Sheets("Sheet1").Range("A2").va lue =workbooks("Book2").Sheets("Sheet1").Range("A1").v alue or myVar=workbooks("Book1").Sheets("Sheet1").Range("A 2").value or MyFunction(workbooks("Book1").Sheets("Sheet1").Ran ge("A2").value ) This may not be robust as it assumes the names of the workbooks and sheets etc etc. What you cannot do so easily is cross-reference a variable in the VBA code of one workbook in another. "Steph" wrote: Hello. I have a workbook with a click event. The click event opens another workbook and runs a procedure in the newly opened workbook. I would like to read the contents of of Sheet1, cell A1 in the file that houses the click event, and be able to use that variable in the code in the workbook that the click event opened. Can this be done?? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use variable across workbooks
That's part of the problem - I won't know the name of the file or sheet name
of the workbook that houses the click event whic then opens and runs the code in the newly opened workbook. So somehow I need the contents of cell A1 to carry over and be available to me in the newly oppened workbook. "AA2e72E" wrote in message ... Yes you can; you'll get the idea from this: workbooks("Book1").Sheets("Sheet1").Range("A2").va lue =workbooks("Book2").Sheets("Sheet1").Range("A1").v alue or myVar=workbooks("Book1").Sheets("Sheet1").Range("A 2").value or MyFunction(workbooks("Book1").Sheets("Sheet1").Ran ge("A2").value ) This may not be robust as it assumes the names of the workbooks and sheets etc etc. What you cannot do so easily is cross-reference a variable in the VBA code of one workbook in another. "Steph" wrote: Hello. I have a workbook with a click event. The click event opens another workbook and runs a procedure in the newly opened workbook. I would like to read the contents of of Sheet1, cell A1 in the file that houses the click event, and be able to use that variable in the code in the workbook that the click event opened. Can this be done?? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retrieving data from variable workbooks | Excel Discussion (Misc queries) | |||
Variable Link to Workbooks | Excel Worksheet Functions | |||
Passing a variable between workbooks | Excel Programming | |||
Sharing variable values between open workbooks? | Excel Programming | |||
How to refer a Variable across Workbooks ? | Excel Programming |