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.

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.

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.

Paige,
Can't you save the .123 file in some compatible format, e.g. .cvs ?
Use ADO to query the .123 file ?

NickHK

"Paige" wrote in message
...
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.