Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Access a Range in Another Workbook
This seems pretty trivial but it's not clear to me how to do refer to
range object in an external source. I want to access and use a named Range in a second workbook. I'm thinking that I can declare a Range variable in my ActiveWorkbook and set that equal to the external range. So: Say the primary Workbook is Model.xls and the one I want to access is Data.xls, and the Data named Range is DRange So in a Model module Sub Something() Dim rng as Range Set rng = Workbooks("Data.xls")...Range("DRange") But I don't know how to finish the line. I know I'm not asking for clever, only mundane. But if you could help that would be great. Thanks, SteveM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking workbook and range protected Excel sheet to Access | Excel Discussion (Misc queries) | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Access closed workbook range in Custom functions | Excel Programming | |||
Access closed workbook range in Custom functions | Excel Programming | |||
Can't access to a WorkBook | Excel Programming |