[INDENT]I am looking for help to create the best macro that will transfer for me the information as it appear in the attached workbook sheet(sheet2) column A&B to Column E , basically this is the transfer of lotus macro to excel VBA macro which I have done myself . the problem is that I have many of those and I am trying just to save time and therefore I am looking for macro to do that any idea ?????
[/INDENT]
transfer data from Lotus macro to Excal VBA macro
-
-
-
Re: transfer data from Lotus macro to Excal VBA macro
I don't know of any. You could pay someone to do it.
This might help if you want to do it yourself. It has a we1277.doc file that shows command equivalents. http://download.microsoft.com/…/1/WIN98/EN-US/We1277.exe
-
Re: transfer data from Lotus macro to Excal VBA macro
thank you for the info I tried to download the file you suggested me to download but eventually it does not work with my version of windows (win 7) , secondly I am not looking for the conversion fro lotus to VBA , what I basically need is a macro that do the following when I have the every when I the following :- "{SELECT B:J1470}", remove the { & } ,then replace the word "SELECT B:" (only) with the word Range(", and leave the J1470 as Is the close prentice with ") and add .value in the end so the final result will look like range("J170").value
hope you I am clear with my explanation -
Re: transfer data from Lotus macro to Excal VBA macro
Cross-post: http://www.vbaexpress.com/foru…-macro-to-Excal-VBA-macro
-
Re: transfer data from Lotus macro to Excal VBA macro
sorry rollis13 I don't understand your message , your link sending me back to my thread that I posted today and which I am trying to find solution
-
-
Re: transfer data from Lotus macro to Excal VBA macro
Sounds like you want to make your own converter. If you have an Excel version prior to 2000, it could do most of it possibly.
You might want to reconsider adding the .Value. In another case, the same string had a .Select added. Whether to use the .Value or .Select would depend on your column B data on that row.
This will give you an idea. I don't see a need to remove the sheet name for that string. You will need to remove a 2nd sheet name though sometimes. e.g. A:A1..A:A2 would be A!A1:A2 in Excel.Code
Display MoreSub test_fSelect() Dim s As String s = "{SELECT Sheet1:A1}" MsgBox "Before: " & s & vbLf & "After: " & fSelect(s) End Sub Function fSelect(aString) As String Dim s As String s = Replace(aString, "{SELECT ", "Range(") s = Replace(s, "}", ")") s = Replace(s, ":", "!") s = Replace(s, "..", ":") fSelect = s End Function -
Re: transfer data from Lotus macro to Excal VBA macro
Quote from michel5000;704979sorry rollis13 I don't understand your message , your link sending me back to my thread that I posted today and which I am trying to find solution
michel5000, some light reading: http://www.excelguru.ca/conten…ge-to-forum-cross-posters
For others, also cross posted at:http://forum.chandoo.org/threa…to-excal-vba-macro.15222/ -
Re: transfer data from Lotus macro to Excal VBA macro
Hi kennet
Thank you for yourreply , I have some question for clarification , 1) I got office 97 , do youthink that it will work with my windows7 or I need to find another computerwith earlier version of windows? 2) Regarding your code, is the sub test partshould go in a module, and the function part in the sheet itself or what? Sorrynot so familiar with VBA , another thingif you opened the workbook I sent , I basically looking for macro that everytime the work SELECT & Row number appear in column A and CELL ENTER in the same Row incolumn B to change that to one line as range("J1470").value=Sheets("D").range("N7").value,(asI wrote manually in column E ) I agreewith and I don’t have a problem with your idea to use the “replace” functionexcept “=value” function, I hope I amnot asking for too much from you , can you try and write for me the macro that ineed , I tried to write macro with “IF” statement and string to find part ofword and change to what I need but it not working for me , last thing is that Iwould like in my macro that the translation/replacement result from column Awill place in column E , because originally what I have is only the informationin columns A&B -
Re: transfer data from Lotus macro to Excal VBA macro
P45cal , thank you for the information . I promise to do better , and I think that you right with your remark , but what to do I am so desperate to find a solution to my problems that I don't know what to do anymore , but let's hope that I will get it soon , and gain thank you
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!