I in process of converting project from lotus 123 script to excel VBA , I have been doing long research I found some material but could not find an answer to the following is someone can tall me what is {SET "MACRO-TRACE";"OFF"} , and {SELECT-APPEND B:P1628;B:P1628} mean in VBA and what are the lines in VBA that equivalent to those lines thank you in advance for any help
change the title to macro translation from lotus 123
If solved remember to mark Thread as solved
Dear Pilot5000,
Below is solution I have searched from google. Please try.
If you are transfering the macro from 1-2-3 into a version of MS Excel prior to MS Excel 2000 (i.e. a version from the 90s or earlier) or MS Excel 97 not yet updated to 8.0h or later, this is actually feasible.
You open the 1-2-3 worksheet with the macro in Excel, then press Alt-Spacebar and click Run, then click Macro Translator, then click OK
In the Translate menu, click Lotus 1-2-3. Select name of the worksheet.
Select the name of the macro to convert.
If you want to have a listing of the 1-2-3 macro beside the converted MS Excel macro, click the Verbose option.
For later versions of MS Excel, though, this is basically an impossible task.
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
Dear Nandkumar S.
I tried to do that and I even installed ms excel 97 in my other computer but it didn't work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks