Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
nela
 
Posts: n/a
Default converting a lotus file into excel.

Hi

I have a file that is in Lotus 123, I don't like working with theis file is
there any way i can convert the file tinto excel. The lotus file had macros
and i need to keep them.

Thanks a million
--
nela
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default converting a lotus file into excel.

Depends on the format of your 123 file (excel can open .wk* files, not .123
files).

And depends on your version of excel. IIRC, xl2003 (xl2002???) doesn't support
123 macros.

I just checked xl2003's help.

It says that xl2k+ won't run lotus 123 macros.



nela wrote:

Hi

I have a file that is in Lotus 123, I don't like working with theis file is
there any way i can convert the file tinto excel. The lotus file had macros
and i need to keep them.

Thanks a million
--
nela


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default converting a lotus file into excel.

There are several 1-2-3 file formats. The newest is .123 which Excel cannot
read. But if you can save the file in WK4 format Excel can read it. If
your macros are the old style I'm familiar with (text in cells) the macros
will be preserved since they are just text to Excel. You cannot run them in
Excel however.

--
Jim
"nela" wrote in message
...
| Hi
|
| I have a file that is in Lotus 123, I don't like working with theis file
is
| there any way i can convert the file tinto excel. The lotus file had
macros
| and i need to keep them.
|
| Thanks a million
| --
| nela


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open a Lotus 1-2-3 file using Excel 2003 Teri Excel Discussion (Misc queries) 3 April 5th 07 07:44 AM
How do I unlock FILE access? rcmodelr Excel Discussion (Misc queries) 7 November 12th 05 09:55 PM
File size too big after converting Lotus 1-2-3 to Excel Learner Excel Discussion (Misc queries) 3 June 10th 05 08:27 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
How save a lotus 2.2 file in excel and to open it in excel and pe. bird New Users to Excel 0 February 26th 05 01:57 AM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"