Hi, Nick. I'm looking for a code solution; so far, no luck though; since the
file I need to get the data from is a .123 file.

"NickHK" wrote:

Paige,
Can you not just Copy/Paste into Excel?
Or are you looking for a code solution ?

NickHK

"Paige" wrote in message
...
Is it possible to open (with code) a Lotus .123 workbook in Lotus and copy
some data (or a named range) from it to Excel, or if not, to have code
that
can go to an open .123 workbook and select a named range in that .123
workbook and copy it over to the Excel workbook. In all the reading I've
done, it appears that you cannot open/import a .123 file (or range) into
Excel, but wasn't sure about the above. I cannot convert my .123 to .wk4
(or
other .wk*) or text due to the number of sheets/rows and other programming
requirements. I'm just trying to get to that .123 file and copy a range
from
it into Excel. Appreciate any expertise in this; thanks.