Hi all:

I'm trying to find the easiest way to programatically copy a named range
in one workbook (normally unopened) into a corresponding target range in my
open workbook. This is part of a conversion from Lotus 1-2-3 to Excel. In
1-2-3, the command RangeCombine, as part of the Range object in LotusScript,
handled the task of opening the specified worksheet, locating the named
range therein, and then copying that range to the range specified in the
Range Object associated with the RangeCombine command. For example:

lrMyDestinationRange.RangeCombine lcFromFilePathAndName, , , ,
$CombineReplace, "PNAME"

whe
- lrMyDestinationRange is the Range object into which the new values
will be placed,
- lcFromFilePathAndName is a string value holding what its name
implies,
- $CombineReplace is a LotusScript-specific value indicating that
the new data should Replace any existing values,
- "PNAME" is the name of the range in the external worksheet.

Does anyone have any good, quick, easy ideas on how this same type of
thing can be implemented in Excel VBA?

Any and all help will be GREATLY appreciated!

Thanks,

Jon