Excel consulting and custom programs

Website Links

Description

Lotus Macro Conversion - convert your macros to Excel. Consulting services and help. Lotus macro conversion -- convert wk1, wk3, wk4 macros to excel What about converting old Lotus spreadsheets to Excel? MaKro Consulting has extensive experience with Lotus version 2 macro programs. The Home Loan program on this site was created using the old DOS Lotus 2.3 macro language. Many of these Lotus macros will run properly under Excel. By converting these old spreadsheets to Excel you gain access to the formatting, programming, and graphics power that Excel has to offer. Any problem routines can either be corrected within the Lotus macro or re-written using Excel visual basic programming. Please note that you should exercise caution towards spending a lot of time or money to fix the original Lotus macros so that they work perfectly in Excel. After you see what can be done with Excel visual basic, command buttons, message boxes, pull down menus, etc... you may decide that it is preferable to convert these macros to Excel. If the original Lotus macro can be fixed quickly and easily, then it is worth a try. Otherwise, you should think about converting them to Excel visual basic. Also, consider the possibility that the next version of Excel will not have as extensive support for the Lotus macros as we enjoy today. In general, Excel visual basic routines run smoother in Excel than Lotus macros. Thus, we usually end up re-writing them in visual basic. Simple Lotus macros (print, query, etc) can be re-done fairly quickly, even if they already work properly in Excel. If you are having occasional problems or you just don't like the way that your Lotus macros compare to the others, consider converting the macros. What about very complicated and extensive Lotus macro programs? That is a tough question. First, you probably want to try running your lotus macros in Excel (use Ctrl-? instead of Alt-? as in Lotus 2.x). If some of them seem to work OK and a few of them don't, then it might be worth modifying the original Lotus macro to make it work the desired way. If none of them seem to work real well, then you might want to convert most/all of them to Excel visual basic. Or, if you don't have a strong need for the Excel features, you could just keep running them in Lotus. Another thing to consider: What appears to be a very complicated Lotus macro may actually be fairly easy to convert to Excel. Some macros have miles of code that only give you a few inches worth of results. Over 15 years spent writing Lotus macros makes all of them a bit easier to understand and convert. The first step in any macro/sheet conversion from Lotus to Excel should be an overall review of what the Lotus macros and spreadsheet are doing. Sometimes, there are easier ways to do the same things now in Excel than there were several years ago when the Lotus macros were written. In addition, the person that wrote the macros probably knew very well what they wanted to do, but they were maybe not aware of more advanced spreadsheet techniques that they could use to do what they wanted in an easier way. Hard drive capacities change, processor speeds change, and spreadsheet features change.

Products & services

Similar companies nearby