Lotus 123 to Excel

P

Paige

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.
 
N

NickHK

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

NickHK
 
P

Paige

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.
 
N

NickHK

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

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top