Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaSagar your suggestion may end up working but I'm running into an issue. We have two versions of Excel installed. 2003 is installed so we can run the old macros. 2010 is installed because we have upgraded to that (some time ago) and we want the macros to work with it. When the CreateObject("Excel.Application") line runs, it runs in 2003. Is there a way to specify? Trying to avoid uninstalling 2003 if possible.
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil, it will probably take me some time to parse through the info there. I was hoping to avoid opening new sessions, since we are constanly in one and every desktop has different session profile names/login information/desktop paths where the session profile is stored/etc. No way to target an open session?
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil, it will probably take me some time to parse through the info there. I was hoping to avoid opening new sessions, since we are constanly in one and every desktop has different session profile names/login information/desktop paths where the session profile is stored/etc. No way to target an open session?
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil, it will probably take me some time to parse through the info there. I was hoping to avoid opening new sessions, since we are constanly in one and every desktop has different session profile names/login information/desktop paths where the session profile is stored/etc. No way to target an open session?
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNot AFIK. You will have to use Rumba scripting from an already opened session to control Excel. I'm not sure how you will get around your multi version environment though.
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaUpdate:
I have a new solution which involves using only the script editor. It is much faster and so far bug free. I use the following code to launch Excel (allbeit the wrong version until I get 03 uninstalled) and turn the data I need copied into a variable instead of using the system clipboard. I will post the code for launching Excel, since I think was the most helpful to me, and if anyone is interested in the full code I am using, just ask and I can provide it for you. Thanks again to everyone for all of the help!!
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
XLApp.Workbooks.Open Filename:="P:\\etc.. \\ERPData.xls"
SysDelay 1
Set MYBook = XLApp.Workbooks("ERPData.xls")
Set XLSheet = MYBook.Worksheets("Sheet1")
Set XLSheet2 = MYBook.Worksheets("Sheet2")
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaUpdate:
I have a new solution which involves using only the script editor. It is much faster and so far bug free. I use the following code to launch Excel (allbeit the wrong version until I get 03 uninstalled) and turn the data I need copied into a variable instead of using the system clipboard. I will post the code for launching Excel, since I think was the most helpful to me, and if anyone is interested in the full code I am using, just ask and I can provide it for you. Thanks again to everyone for all of the help!!
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
XLApp.Workbooks.Open Filename:="P:\\etc.. \\ERPData.xls"
SysDelay 1
Set MYBook = XLApp.Workbooks("ERPData.xls")
Set XLSheet = MYBook.Worksheets("Sheet1")
Set XLSheet2 = MYBook.Worksheets("Sheet2")
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaThis is very helpful. Great post Neil! I was able to successfully open a session and scrape data back to excel using your code, but I am struggling with how to send data from excel vba to session. For example, we have a list of account numbers in excel which needs to be sent to rumba session one at a time, screen scraped, pasted back to excel and then repeat with the next account number. I'm struggling on how to paste the account number using the code above.
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaThis is very helpful. Great post Neil! I was able to successfully open a session and scrape data back to excel using your code, but I am struggling with how to send data from excel vba to session. For example, we have a list of account numbers in excel which needs to be sent to rumba session one at a time, screen scraped, pasted back to excel and then repeat with the next account number. I'm struggling on how to paste the account number using the code above.
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaHi,
If you use the raw API call WD_SendKey to send data directly, without compensating for screen update timings you will more than likely excede the buffer level of the session and get unexpected results, but here's the code anyway.
nResult = WD_SendKey(1, "Some text data")
To get around timing issues I created the Function WaitFor Cursor() This sends the data to Rumba, then waits for a number of seconds for the cursor to reach the expected point on the screen. I'll post some example code based on the following premises:
1. You've logged on and have an open connection.
2. You've managed to send keys to navigate to the point in your Rumba session where you need to enter the data
3. you know exactly the screen position of the field (this is shown as row and column in the status bar at the bottom). I've used row 22 column 35 as an example
4. The data is on the active spreadsheet in A2:A100
air code (untested):
For nRow = 2 to 100 'Loop through Data
MyData = Range("A" & nRow) ' put data into a variable
WaitForCursor(MyData, 22, 35 len(MyData)) 'send variable to screen and wait for cursor position
WaitforCursor(ENTER, 22,35) 'send carriage return and wait for cursor position
next nRow
ENTER is a constant privided in the module I posted representing the key code '"@E", which is used for the enter key, or carriage return.
You need to caclulate where the cursor will end up after entering the data. Use the current cursor column position plus the length of the string. Also take into account the row position. I key data manually and make notes of the positions to code later.
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaThanks Neil. Worked perfect!!
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaThanks Neil. Worked perfect!!
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaThanks Neil. Worked perfect!!
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil,
I have a small doubt regarding the dll which you have used..here u have used ehlapi32.dll for connecting rumba and created custom functions for the get,set or senddata...while I was connecting, I have used the objectXMFdisplay.dll for connecting to rumba session in which I need not create the seperate functions for all the operations..
Could you let me know the difference between both?? I am a newbie to this and recently I got some code which will connect to rumba thru excel and when I was back tracing I found this..If u could tell me the difference it will be very helpful for a rookie like me..
Thanks in Advance
Jithin
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil,
I have a small doubt regarding the dll which you have used..here u have used ehlapi32.dll for connecting rumba and created custom functions for the get,set or senddata...while I was connecting, I have used the objectXMFdisplay.dll for connecting to rumba session in which I need not create the seperate functions for all the operations..
Could you let me know the difference between both?? I am a newbie to this and recently I got some code which will connect to rumba thru excel and when I was back tracing I found this..If u could tell me the difference it will be very helpful for a rookie like me..
Thanks in Advance
Jithin
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil_ how can you use scripting in RUMBA and make it work in excel? Like if i want to select a range("a1") as an example. How do you set up the connection ?
Our company is using Rumba 8.1 and we are running into difficulties with macros. There have been long standing issues with trying to get Excel 2010 and Rumba to play nice as far as copy/paste macros go. The most stable version of the macro that we have will copy data from Excel and paste to Rumba using the Rumba macro. This macro works fine for some time, but we need to run it to copy hundreds of different cells. There are several distinct points the macro likes to give up and say "Macro copy failed" or something along those lines (around the 20th, and 52nd copy or so). Oddly enough, if the code passes those two trouble spots, it finishes unhindered. Another issue occasionally arises where, while running the code or upon completion/termination at the trouble spots, Rumba will just stop working all together and the session will crash.
I'm looking for a solution that will enable me to use the Rumba macro language to copy several hundreds, even thousands of items from Excel and paste it into Rumba, without stopping or crashing.
I have tried several different version of the Rumba macro, tried utilizing VBA code in Excel to compliment what I do in Rumba, but nothing seems to be working well. I can go into more detail about things I've tried if anyone has any ideas.
We are running 64bit Windows 7 SP1
#Windows7#Rumba8.1#macros#RumbaNeil_ how can you use scripting in RUMBA and make it work in excel? Like if i want to select a range("a1") as an example. How do you set up the connection ?
