| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a range in a different open workbook from the active one
I want to set a range in different workbook, PayRollCarryOver, from the
currently active one. PayRollCarryOver is open but not active. What is the proper syntax for the link to another workbook? I tried this, but got an error: Set newCarryover = Range("[PayrollCarryOver.xls]'Carryover'!A1") Thank you. John Wirt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Defining a range in a different open workbook from the active one
John,
Work you way through the Object Model: Dim newCarryover as Range Set newCarryover = Workbooks("PayrollCarryOver.xls").Worksheets("Carr yover").Range("A1") NickHK "JWirt" wrote in message ... I want to set a range in different workbook, PayRollCarryOver, from the currently active one. PayRollCarryOver is open but not active. What is the proper syntax for the link to another workbook? I tried this, but got an error: Set newCarryover = Range("[PayrollCarryOver.xls]'Carryover'!A1") Thank you. John Wirt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to open a workbook per active window | Excel Discussion (Misc queries) | |||
| Why does a new Excel Workbook open with IV1 as the active cell? | Excel Discussion (Misc queries) | |||
| Making an open workbook active | Excel Programming | |||
| Get range value active workbook on open add-in | Excel Programming | |||
| How do I make an open workbook the active workbook | Excel Programming | |||
Hybrid Mode
