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 |