I have written a spreadsheet with lots of code for work. You guiys have help greatly with that thank you. But I have since been asked to convert the whole thing into lotus 123. I know it is possible but I have never used lotus 123 is it going to be easy (ish) and does anyone know what language I will need to use? Any help even online tutorials I can look at would be a great help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Strange Request
- Thread starter radar82
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Just tell them "NO".
Lotus 123 is way behind Excel these days -- IBM hasn't put any effort into it for quite a while. Last time I tried to use Lotus was in 2000, and Excel's VBA was way ahead even then.
On the formula side there shouldn't be too much of an issue but if you have a lot of code you will be rewriting large sections of it, if not from scratch.
If you really feel the need to have a go, run a Google search for LotusScript. This should get you started:
http://www.nsftools.com/tools/lsbook.htm
http://www.redbooks.ibm.com/redbooks/pdfs/sg244856.pdf
Denis
Lotus 123 is way behind Excel these days -- IBM hasn't put any effort into it for quite a while. Last time I tried to use Lotus was in 2000, and Excel's VBA was way ahead even then.
On the formula side there shouldn't be too much of an issue but if you have a lot of code you will be rewriting large sections of it, if not from scratch.
If you really feel the need to have a go, run a Google search for LotusScript. This should get you started:
http://www.nsftools.com/tools/lsbook.htm
http://www.redbooks.ibm.com/redbooks/pdfs/sg244856.pdf
Denis
Upvote
0
I don't really want to have a go at it but managment doesn't want to spring for a copy of office on every computer at every location around the state so I have to look into it.
I get to work on it during work hours so its up to them really. Personally I would pay for the licenses for office.
Ill look through those websites and see how I go.
cheers
I get to work on it during work hours so its up to them really. Personally I would pay for the licenses for office.
Ill look through those websites and see how I go.
cheers
Upvote
0
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
So, is your office still on SmartSuite?
You'll find that the link to the Redbook (the second one) compares LotusScript to VB4. Office switched to VB6 in Office 2000, to give you an idea of how far behind that book is. The first link is for a project that was abandoned in 2003...
Another option to look at (not one that I have used) is the Lotus point and click macro language. Still, it's a lot of work to go to for an office suite that stagnated years ago. Good luck with convincing your boss, or doing the conversion...
Denis
You'll find that the link to the Redbook (the second one) compares LotusScript to VB4. Office switched to VB6 in Office 2000, to give you an idea of how far behind that book is. The first link is for a project that was abandoned in 2003...
Another option to look at (not one that I have used) is the Lotus point and click macro language. Still, it's a lot of work to go to for an office suite that stagnated years ago. Good luck with convincing your boss, or doing the conversion...
Denis
Upvote
0
Dave Patton
Well-known Member
- Joined
- Feb 15, 2002
- Messages
- 6,335
- Office Version
- 365
- 2010
- Platform
- Windows
fyi
IBM may be promoting a version of Open Office. Quote fromCnet
"IBM Lotus Symphony is a free productivity software suite for both Windows and Linux users. IBM has resurrected the Symphony name from the early 1990s, but don't confuse the new Symphony with the failed effort of the past.
This suite, which remains in beta testing, consists of word processing, spreadsheet, and presentation applications. IBM's Documents, Presentations, and Spreadsheets are foils to Microsoft's Word, PowerPoint, and Excel. Our early look at Symphony reveals the package to be closer to that of the free, open-source OpenOffice than Microsoft's nearly ubiquitous and all-encompassing suite. "
I have no direct information on the above.
IBM may be promoting a version of Open Office. Quote fromCnet
"IBM Lotus Symphony is a free productivity software suite for both Windows and Linux users. IBM has resurrected the Symphony name from the early 1990s, but don't confuse the new Symphony with the failed effort of the past.
This suite, which remains in beta testing, consists of word processing, spreadsheet, and presentation applications. IBM's Documents, Presentations, and Spreadsheets are foils to Microsoft's Word, PowerPoint, and Excel. Our early look at Symphony reveals the package to be closer to that of the free, open-source OpenOffice than Microsoft's nearly ubiquitous and all-encompassing suite. "
I have no direct information on the above.
Upvote
0
