ExcelBanter - Importing

Hi,

About converting worksheets between Excel and Lotus 1-2-3
Some of the content in this topic may not be applicable to some languages.

Converting files

Saving in Microsoft Excel file format Excel stores the file format of any
file you open. When you save a file, Excel uses the same format the file was
in when you opened it. For example, if you open a Lotus 1-2-3 file with a
..wk3 extension, Excel saves the file as a Lotus 1-2-3 file with a .wk3
extension. If you make changes to the file in Excel, you should save the file
in an Excel file format to be sure all of your changes are saved. To do this,
be sure to use the Save As command and select Microsoft Excel Workbook in the
Save as type box.

Changing the file name extension When you save a workbook as a different
type by changing the file format in the Save as type box, you do not have to
change the file name, because Excel saves a copy of the workbook with a
different file name extension. For example, a Lotus 1-2-3 Release 4.0 file
has a file name extension of .wk4; Excel Workbook format uses the .xls file
name extension.

Typing a new extension in the File name box, or renaming the file with a new
extension in the folder window, is not sufficient to change the file type.
You must also change the Save as type box to the file type you want.

Applying formatting from associated Lotus 1-2-3 files When you open a
Lotus 1-2-3 worksheet or workbook in Excel, Excel applies the formatting in
the associated .fmt, .fm3, or .all file. Make sure the associated file is
stored in the same folder as the .wk? file. If you save a Lotus 1-2-3 file in
Excel format, Excel saves the spreadsheet data and formatting in a single
workbook file.

Converting formulas

Using Lotus 1-2-3 rules to calculate formulas When you open a Lotus 1-2-3
worksheet in Microsoft Excel, the Transition formula evaluation check box is
automatically selected for that sheet to ensure that Excel calculates the
formulas according to the Lotus 1-2-3 rules.

If you save a Lotus 1-2-3 worksheet as an Excel worksheet, the Transition
formula evaluation check box remains selected and Excel will calculate the
formulas according to the Lotus 1-2-3 rules until you clear it.

How cells are used in formulas Once you have converted a Lotus 1-2-3 file
to an Excel workbook, you can examine the relationships of the cells and
formulas within the worksheet by using the worksheet audit commands.

Some formulas may not convert If a formula can't be converted to an Excel
formula, the worksheet shows the last value calculated for the formula in
Lotus 1-2-3.

Converting macros

Microsoft Excel 2000 and later versions do not run Lotus 1-2-3 macros. You
can rewrite any macros that you need in Visual Basic for Applications. For
information about writing Excel macro code, see Visual Basic Help (Microsoft
Visual Basic Help: To get help for Visual Basic in Excel, point to Macro on
the Toolsmenu, and then click Visual Basic Editor. On the Help menu, click
Microsoft Visual Basic Help.).

Challa Prabhu

"rb999" wrote:

Hi

Is there a way to import .123 files into excel 2007 ?

Thanks